postgresql - Alias in KNEX with Postgres db

Question

The code in knexjs like below

.select("resources.id")

will be translated to below SQL

SELECT "RESOURCES"."ID"

But PostgreSQL only recognized RESOURCES.ID , not"RESOURCES"."ID" as valid column

Is this a known issue? Is there any suggestion apart from using SQL raw?

question from:https://stackoverflow.com/questions/65866395/alias-in-knex-with-postgres-db

Answer 1

You need to use the wrapIdentifier to remove the quotes

const knex = require('knex')({
    client: 'pg',
    wrapIdentifier: (value, origImpl, queryContext) => value});

http://knexjs.org/#Installation-wrap-identifier