Select with list of fields from an array doesn't work with fields including a dot

[mohe2015]

Code similar to the following doesn't work:

sql`SELECT ${sql(["projects.id"])} FROM projects`

because this generates:

SELECT "projects.id" FROM projects;

which is not valid for postgresql

[porsager]

Are you trying to select the key id from a json object in the projects column?

[mohe2015]

No, I'm trying to select the id column from the projects table. So just using the explicit syntax where you specify the table name also.

[mohe2015]

In theory useful for:
SELECT projects.id, users.id FROM projects, users;
although this doesn't create nice column names so probably not worth it.
Feel free to close.

[porsager]

Ah right, of course 👍

There should definitely be a way to do that.. If we make it work as you tried there we'd break anyone with periods in their column names, but I kind of feel that's ok?

[mohe2015]

I would assume the problem is sql injection but I don't know. The correct way to do this with arbitrary names (excluding ones containing a dot) is SELECT "projects"."id" FROM projects;

I would assume that a dot is such a strange thing in a column name that it should be fine. Should still be noted in the release notes of course.

[mohe2015]

I don't need this feature currently so if nobody else needs it it may be worth to wait until the dynamic queries feature is more finished and maybe it's then built in there

[ersinakinci]

I would very much like to see this implemented, as would #731.

Is there a workaround?