e.g. select * from some_table where myid = {{table1.selectedRow.data.myid}}
However, this does not work for Postgres unless you disable converting queries to prepared statements
My understand was that this setting is there to prevent SQL injection attacks? However, it seems a lot of functionality doesn't really work with it enabled.
No, never have needed to disable it.
I'm also using Postgres and use statements like the above all the time.
Might be something else going on here, when you say it doesn't work does it return an unexpected value or an error?
We might want to sort out the basics first then.
The simple select * example in your original post "doesn't work" for you unless you disable prepared statements?
What result do you get in both cases and what errors?