I am using databases package in my fastapi app.  databases has execute and fetch functions, when I tried to return column values after inserting or updating using execute, it returns only the first value, how to get all the values without using fetch..
This is  my query

INSERT INTO table (col1, col2, col3, col4)
  VALUES ( val1, val2, val3, val4 ) RETURNING col1, col2;
I had trouble with this also, this was my query:

INSERT INTO notes (text, completed) VALUES (:text, :completed) RETURNING notes.id, notes.text, notes.completed

Using database.execute(...) will only return the first column.
But.. using database.fetch_one(...) inserts the data and returns all the columns.
Hopes this helps
Get whole row using database package execute function