for me the value of an ORM is not so much query synthesis as serialisation of object fields to db columns and vice versa
I'd love to have a tool that just generates an object type for a given SQL query's result rows, and a function signature for its query parameters.
We don't need ORM, we need OQM (object-query mapping)!
For a similar purpose in Python I generally use psycopg with namedtuple resultsets; the namedtuple 'records' do what I need for the returned data and are reasonably efficient.
If you want to keep going forward with it, I'd recommend working on making it clearer what the examples do, and looking at sqlc for Go for inspiration. Of the existing versions of this people replied with, that one had the clearest API, or at least clearest explanation on its landing page.