search

nilenso / honeysql-postgres

PostgreSQL extension for honeysql
http://nilenso.com
Eclipse Public License 1.0
193 stars 28 forks source link

Subquery alias error #43

Open jpmonettas opened 4 years ago

jpmonettas commented 4 years ago

Hi, I'm running into the subquery in FROM must have an alias error when generating a sub query and attempting to run it in postgres.

(sql/format {:select [:type]
             :from [[{:select [[:address :field-alias]]
                      :from [:Candidate]} :sub-q-alias]]}
            :parameterizer :postgresql)

;;=> ["SELECT type FROM (SELECT address AS field_alias FROM Candidate) sub_q_alias"]

Postgres instead of :

.. FROM (SELECT ...) sub_q_alias

seems to need :

.. FROM (SELECT ...) AS sub_q_alias

I reported the same issue in the original honeysql repo https://github.com/seancorfield/honeysql/issues/263, but I imagine the solution here can be different and maybe easier than there.

Thanks!!