shardingsphere-proxy5.5 datasource is postgresql，when select keywaord an error is reported ，For example position keyword

[lijuchuan]

problem：

select position from test；

error：
dhri=> select position from org_staff;
ERROR: You have an error in your SQL syntax: no viable alternative at input 'selectpositionfrom'

i changed to：
dhri=> select 'position' from org_staff;
?column?

position
position
position

[zzyReal666]

I had a similar problem in distSQL.Because my field is name, but name is the distSQL keyword.

[lijuchuan]

I had a similar problem in distSQL.Because my field is name, but name is the distSQL keyword.

how do u solve it？

[zzyReal666]

I had a similar problem in distSQL.Because my field is name, but name is the distSQL keyword.

how do u solve it？

I changed name to t_name.Because it's the most direct and the fastest.I have an untested idea.If you have to use keywords as column names, I'll try later to see if my idea solves this problem.

[github-actions]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

[zzyReal666]

Which version do you use, I use the latest version test can run select "position" from test;

real database ,both select position from test and select "position" from test success execute:

proxy database,only select "position" from test success execute:

[zzyReal666]

Use double quotes instead of single quotes.