You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Allow the possibility to optionnaly add "AS" in the From clause for CustomDialect #1784
Some dialect like Oracle do not support "AS" in the from clause and failed for some query :
eg that is working or Oracle :
SELECT SRC.*, SYSDATEAS CopyDate FROMTPCH_IN.ORDERS_FLAT SRC WHERE1=1AND O_ORDERKEY BETWEEN 100and1000
whereas this is not working (on Oracle)
SELECT SRC.*, SYSDATEAS CopyDate FROMTPCH_IN.ORDERS_FLATAS SRC WHERE1=1AND O_ORDERKEY BETWEEN 100and1000
Currently the sqlparser force the addition of the keyword AS between the table and it's alias even the original query does not contains "AS" in its from clause.
I don't see the ability to create a custom dialect to avoid this behavior.
I am not sure but i think the "problem" could be here :
changed the title [-]Allow the possibility to optionnality add "AS" in the From clause for CustomDialect[/-][+]Allow the possibility to optionnaly add "AS" in the From clause for CustomDialect[/+]on Mar 31, 2025
Activity
[-]Allow the possibility to optionnality add "AS" in the From clause for CustomDialect[/-][+]Allow the possibility to optionnaly add "AS" in the From clause for CustomDialect[/+]git-hulk commentedon Apr 3, 2025
@rferraton I could support this if you're not on it.
rferraton commentedon Apr 3, 2025
Please do. I have not the level to code in rust :-)
LucaCappelletti94 commentedon Sep 22, 2026
Closing as resolved in #2103