'name' is reserved: cant use 'name' as a column name about vsql HOT 3 CLOSED

That being said, I think the error message should be clearer with a suggestion so it's not so bizarre:

syntax error: near "NAME" (using key word as identifier?)

from vsql.

The SQL standard defines:

<key word> ::=
    <reserved word>
  | <non-reserved word>

NAME falls in the list of non-reserved words. As far as I can tell, the standard doesn't have a rule saying an <identifier> cannot be a <non-reserved word> but this will cause problems with the parser if NAME needs to be a keyword in the future. So as a precautionary measure I register all key words in the parser as off limits.

I realize it's kind of annoying for many common words, but it seems like the safer option to just disallow them all now. You can use "name".

from vsql.

@BEN00262 Turns out you can use non reserved words as identifiers: https://github.com/elliotchance/vsql/releases/tag/v0.24.1

from vsql.