SQLinForm SQL Formatter

Formatting Ideas, Issues and Questions

3 Posts

2 Users

0 Reactions

686 Views

Guido

(@admin)

Member Admin

Joined: 3 years ago

Posts: 216

Topic starter 14/12/2021 5:39 pm

SQLinForm has specific formatting rules for:

There is also a generic formatter called "Any SQL" which should help for many SQL statements.

As there are hundreds of syntax rules for each parser, it is impossible to parse each and every statement correctly.

If you want me to add more formatting rules, please use this forum. Examples will always be appreciated 🙂

This topic was modified 3 years ago 2 times by Guido

Quote

bastiaan

(@bastiaan)

Member

Joined: 2 years ago

Posts: 5

28/11/2022 2:45 pm

Hello Guido,

In version 6.22.10, I see Snowflake listed as a data base. That is great.

Could you add all Snowflake Keywords to your keyword list?

I tried to add LATERAL FLATTEN to the Keyword list in a Profile, with Keywords as UPPER CASE but nor lateral nor flatten is converted to UPPER.

ReplyQuote

Guido

(@admin)

Member Admin

Joined: 3 years ago

Posts: 216

Topic starter 28/11/2022 8:52 pm

Hi bastiaan, thanks for your feedback. Will start adding these keywords soon.

Could you please post a screen shot of how you added your upper case keywords in the profile

Regards

Guido

ReplyQuote

For which Databases can SQLinForm format SQL statements?