invalid reference to FROM-clause entry for table

[SladeThe]

Hi

I get the invalid reference to FROM-clause entry for table error just searching an entity by ID:

conn.WithContext(ctx).Q().Find(&row, id)

I've made some investigations and found that pop incorrectly formats query for Postgres schema tables.

It uses table alias while formatting SELECT clause, but forgets about that in WHERE.

Expected Behavior

Pop should execute: SELECT schema_table.xxx FROM schema.table AS schema_table WHERE schema_table.id = $1 LIMIT 1

Actual Behavior

Pop tries to execute: SELECT schema_table.xxx FROM schema.table AS schema_table WHERE schema.table.id = $1 LIMIT 1

Info

Ubuntu 20.04, Pop v5.2.4, PSQL