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)