SQLinForm SQL Formatter

Ideas, Issues and Questions

3 Posts

2 Users

0 Reactions

1,768 Views

Posts: 295

Guido

Admin

Topic starter

Dec 14, 2021 6:39 pm

(@admin)

Member

Joined: 5 years ago

[#3]

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 🙂

2 Replies

Posts: 5

bastiaan

Nov 28, 2022 3:45 pm

(@bastiaan)

Member

Joined: 4 years ago

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.

Posts: 295

Guido

Admin

Topic starter

Nov 28, 2022 9:52 pm

(@admin)

Member

Joined: 5 years ago

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

For which Databases can SQLinForm format SQL statements?