Sometimes ORM wrap columns with quotes

Question

sneko opened this issue 3 years ago · 5 comments

Some ORM wrap columns with quotes as in the example of GORM:

UPDATE "challenges" SET "deleted_at"='2022-07-11 14:52:45.804' WHERE "challenges"."deleted_at" IS NULL

But I get this error:

Syntax error near . \" deleted_at

Note that when testing the followings it works perfectly:

UPDATE "challenges" SET "deleted_at"='2022-07-11 14:52:45.804' WHERE "challenges".deleted_at IS NULL

UPDATE "challenges" SET "deleted_at"='2022-07-11 14:52:45.804' WHERE challenges.deleted_at IS NULL

Is it possible you accept quotes for columns as you do for tables?

Thank you,

Answer 1 · 2022-07-14T12:04:18.000Z

Hi,

indeed it should be handled, and would not be hard to do. Unfortunately I have very few coding time right now sorry. I'll try to get to it soon.

Maybe you can give it a go ?

Answer 2 · 2022-07-18T17:21:58.000Z

Would this be a driver issue? I am having the same issue when using gorm

Answer 3 · 2022-07-19T09:16:22.000Z

Hi,

It should be good for this issue, I'll try to setup a test suite with gorm

Answer 4 · 2022-07-19T09:18:50.000Z

Thank you @proullon !

Note: another thing among GORM issues is #61 (comment) when trying to migrate schemas to the DB.

Answer 5 · 2022-07-19T09:22:56.000Z

Ok, I'll take a look.

I'm also looking for a way to generate the parser from bnf file, I'm spending so much time on parsing and very little on actual feature