9 replies

How get column name with table prefix ?

drizzle orm📚sql

Hi ! I do a custom sql query with drizzle and I have :

WHERE pm.playlist_id = ${playlist.id}

WHERE pm.playlist_id = ${playlist.id}

But I got an error

column reference "id" is ambiguous

column reference "id" is ambiguous

. How can I have the name

"playlist"."id"

"playlist"."id"

instead ? Like with the table name prefix

Thx !

How get column name with table prefix ? - Drizzle Team