I realize there is already a couple of open issues related to this:
However, I was wondering if anyone knows another way to format a number to display as a currency (formatted with commas).
e.g. 1000000 becomes 1,000,000
In my case I am using essql:
SELECT ROUND(dollar_amount, 2) FROM "index"
is there a way to achieve this without the use of the 'money' datatype (I don't think this type is supported in essql yet) or without a number formatting option?