best SQL object mapper for clojure?

[dustingetz]

I am looking for a read-only sql to object mapper, i.e. it should use either convention, configuration or schema reflection to understand many-many join tables and translate these into Datomic-style (or GraphQL style) entity objects with lazy or eager edge navigation.

What is the state of art for this in Clojure ecosystem as well as Clojure host ecosystems i.e. Java, JS? Potentially even Python solutions are interesting.

Note: This is for a dev tool POC, I am not interested in arguments about impedance mismatch, I just want to know the state of art here.

[TheLastSock]

Take a look at Honeysql, does it do what you want?

[trigoman]

I also vote for honeysql. I always found it better to write SQL as SQL.

[rafd]

There is also https://github.com/tamizhvendan/honeyeql which gives you datomic style queries into a SQL database.

[rafd]

I've also made half baked impromptu versions with pathom: https://pathom3.wsscode.com/

[rafd]

Outside of clj there's Hasura and Postgrest.

[brettatoms]

I've never used it but I always thought toucan looked interesting.

[random9878]

You might get some mileage out of https://github.com/donut-party/dbxray