How to build detail views that are populated from separate queries?

Thanks. I've tried referencing tables in queries as you suggest ( where myid = {{table1.selectedRow.data.myid}}) but with Postgres that doesn't work unless a certain setting that is supposed to protect against sql injection is disabled

See '{{}}' cannot be used when using the DO-END statement in SQL and SQL bind error, 6 parameters but requires 0 - #4 by paul

Does everyone just turn this setting off?