Using Reserved Keywords in Column Names

[makssent]

Hello everyone,

I am working on an SQL parser based on Apache ShardingSphere. I have encountered a problem. I have implemented support for CREATE USER. The syntax for this statement looks like this:

CREATE USER username
       <user_option> [<user_option> ...]
       [TAGS (<user_var> [, <user_var> ...]]
      
     <user_option> ::=
         PASSWORD 'password'
       | FIRSTNAME 'firstname'
       | MIDDLENAME 'middlename'
       | LASTNAME 'lastname'
       | {GRANT | REVOKE} ADMIN ROLE
       | {ACTIVE | INACTIVE}
       | USING PLUGIN plugin_name
      
     <user_var> ::=
         tag_name = 'tag_value'
       | DROP tag_name

In the syntax, we use keywords such as: LASTNAME, MIDDLENAME, FIRSTNAME. As a result, we encounter an error in the following query:

INSERT INTO PersonsNew (PersonID, LastName, FirstName, Country, City) VALUES (4, 'Claus', 'Jorgingston', 'USA', 'Chicago')

This query does not pass the parser and returns an error: You have an error in your SQL syntax: CREATE TABLE PersonsNew (PersonID intLastName varchar(255)FirstName varchar(255)Country varchar(255)City varchar(255)Primary key(PersonID)) null.

The query tree looks like this:

line 1:30 no viable alternative at input '(PersonID, LastName'
(insert Insert into (tableName (name (identifier Persons))) ( PersonID , LastName , FirstName , Country , City ) values (4, 'Claus', 'Jorgingston', 'USA', 'Chicago'))

Question: How can I resolve this error if LastName and FirstName are used as keywords?

Please provide answers in a basic format, as I have only recently started programming. Any advice would be greatly appreciated.