More of a feature request – it would be nice to be able to use different colour for SQL functions. Currently they are treated as keywords, but consider this statement:

FIRST_VALUE(order_date) OVER(PARTITION BY customer_id ORDER BY order_date)

in it FIRST_VALUE is the function, while all other capitalised words are reserved words.

Also, I’d like SUM(sales) to be different colour compared to INTERVAL DAY TO SECOND , etc., because functions usually take arguments, while reserved words are just that. It’s handy to be able to quickly tell them apart.

There are also cases where function name is identical to a reserved word, would be nice if formatter can figure out which is which from surrounding code.


  • You must to post comments
Showing 0 results
Your Answer
Post as a guest by filling out the fields below or if you already have an account.