Old left join syntax help

[slp-oozzyy]

Hi,

I am trying to work with older sql queries where the old version of left join is used, for exp:

select *
from x,y
where x.a=y.b(+)

The parser gives out a keyword error, I believe '(+)' is not defined in the parser. I tried to add '(+)' as a new keyword to the parser via dialect but unable to come up with a way to do.

Is it possible to incorporate this into parsing and sql generation processes ?

[georgesittas]

We have no plans to implement this syntax, because it's not widely supported.

Added in #1224.

[nezorepla]

@georgesittas There are many oldest pl/sql veterans who use it this way.

[georgesittas]

I don't doubt that people might still use this, but SQLGlot's not inclined to support it, especially when Oracle discourages its usage.

[nezorepla]

I dont use this format but trying to convert and optimize a lot of old sql queries to a new db using sqlglot, It would be extremely usefull if the parser can pickup (+) in some way. thank you :)

[georgesittas]

@nezorepla added.

[georgesittas]

See #1224