If you use unique names things like powerbi can infer relationships, apparently- even without FKs.
FWIW, next.jdbc
's datafy
/`nav` across result sets assumes :table_id
(or :tableid
) could be a FK relationship to :table.id
, i.e., address.user_id
in the address
table will be assumed to link via select * from user where id = <address.user_id>
when you navigate.
(but you can provide your own :schema
option to override that if you want)