For which Databases can SQLinForm format SQL statements?

3 Posts
2 Users
0 Likes
515 Views
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 175
Topic starter  

SQLinForm has specific formatting rules for:

  • Azure
  • DB2 zOS/UDB
  • Oracle
  • MSAccess
  • MySQL
  • Informix
  • Netezza SQL
  • PostgreSQL
  • SQL Server
  • Redshift SQL
  • Sybase
  • Teradata
  • Vertica
  • Yellowbrick

 

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 2 years ago 2 times by Guido

   
Quote
(@bastiaan)
Member
Joined: 2 years ago
Posts: 5
 

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: 2 years ago
Posts: 175
Topic starter  

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
Share: