[FORMATTING] 'DESC' is not capitalised unlike other SQL keywords #702
Description
Input data
Which SQL and options did you provide as input?
SELECT
o.order_id
FROM
public.orders o
INNER JOIN public.order_details od ON od.order_id = o.order_id
INNER JOIN public.product_detail pd ON pd.product_id = od.product_id
GROUP BY
o.order_id
ORDER BY
SUM(pd.weight) desc
LIMIT
3;Expected Output
SELECT
o.order_id
FROM
public.orders o
INNER JOIN public.order_details od ON od.order_id = o.order_id
INNER JOIN public.product_detail pd ON pd.product_id = od.product_id
GROUP BY
o.order_id
ORDER BY
SUM(pd.weight) DESC
LIMIT
3;Actual Output
SELECT
o.order_id
FROM
public.orders o
INNER JOIN public.order_details od ON od.order_id = o.order_id
INNER JOIN public.product_detail pd ON pd.product_id = od.product_id
GROUP BY
o.order_id
ORDER BY
SUM(pd.weight) desc
LIMIT
3;Usage
- How are you calling / using the library? -> Via the SQL Formatter VSCode Library by Rene
- What SQL language(s) does this apply to? -> Default SQL, Works as expected in PostgreSQL, TransactSQL.
- Which SQL Formatter version are you using? -> v4.0.0