Using custom SQL via ODBC throws errors

[cerequena]

We are trying to use custom SQL as a data source against PostgreSQL, using the latest, official ANSI and Unicode PostgreSQL drivers for Windows.
We are unable to customize the SQL  statement beyond "Select * from table" - anything else throws ODBC errors.
Does anyone know of potential solutions?

[cerequena · Accepted solution]

I discovered that PosgreSQL requires double quotes around all column names to avoid errors.

This solves the issues. Thank you.

[V-pazhen-msft]

@cerequena 

What is the error message? You can try find similar discussions for that specific error message. They usually have fixes in the replies.

e.g.
Solved: Getting Data from ODBC using SQL statement - Microsoft Power BI Community

PostgreSQL Major: "OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the d...

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.