PostgreSQL Case Sensitive Issue

[PlayingForChangeDev]

@bymayo I'm using postgresql and the columns are case sensitive, for example this query

SELECT COALESCE(sum(orders.totalPrice), 0) AS "totalRevenue", COALESCE(count(orders.id), 0) AS "totalOrders" FROM "commerce_orders" "orders" INNER JOIN "elements" "elements" ON elements.id = orders.id

It doesn't work, but if I change it this way it works

SELECT COALESCE(sum(orders."totalPrice"), 0) AS "totalRevenue", COALESCE(count(orders."id"), 0) AS "totalOrders" FROM "commerce_orders" "orders" INNER JOIN "elements" "elements" ON elements.id = orders.id

https://stackoverflow.com/questions/21796446/postgres-case-sensitivity

So no widget works for me