Use the FORMAT function with %'.2f for thousands separators (works with NUMERIC types):
FORMAT
%'.2f
NUMERIC
SELECT FORMAT("%'.2f", 1000000.00) -- output 1,000,000.00