Closed chaupow closed 8 months ago
Thanks for reporting.
Although I apparently have documented this :
-syntax of Redshift, I haven't actually implemented any support for it.
Interestingly I just recently fixed a similar issue for Transact-SQL. So most likely some similar solution could be done in here.
I was mistaken. This syntax was supported, but as the issue title says, the problem was only the case when a keyword occurred after :
.
Now treating :
similarly to .
that's commonly used as a table.column
separator.
Fixed in 15.1.3
Oh wow this was amazing quick!! โกโจ
Thanks so much for fixing so promptly and pushing a new version out ๐ฅน I really appreciate it!
Hi! ๐
Input data
Which SQL and options did you provide as input? with
"language": "snowflake"
Expected Output
Actual Output
Usage
We're using snowflake and unfortunately some of our JSON fields have the key
type
which is identified as a reserved clause and incorrectly put in the next line.We can prevent this by using
details:"type"
but it would be great if it would work without quotes as well.This is especially an issue because we would love to use
"keywordCase": "upper"
but this breaks the query because key names are case sensitive anddetails:TYPE
fails to query the intended lookup.How are you calling / using the library?
What SQL language(s) does this apply to?
snowflake
Which SQL Formatter version are you using?
15.1.2
Thank youuuuuuuuu ๐