Query runs in SQLAlchemy but not PyCharm

ERROR: COALESCE types text and integer cannot be matched

The default column type is text

Ensure that NULL columns have the right type

SELECT
-  NULL AS some_col
+  NUL::NUMERIC as some_col

Last update: 2023-04-24