Skip to content

Subquery alias error #43

@jpmonettas

Description

@jpmonettas

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 seancorfield/honeysql#263, but I imagine the solution here can be different and maybe easier than there.

Thanks!!

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions