I'm using Denodo Express against a MariaDB database.
When I execute the view, the have a syntax error because the SQL statement is not well generated.
Expected SQL : SELECT id, Order_Id, Client_Id, Product_Id, Date, Qty, amount FROM test.orders
Generate SQL : SELECT t0.id, t0."Order_Id", t0."Client_Id", t0."Product_Id", t0."Date", t0."Qty", t0.amount FROM test.orders t0
It seems the double quotes are not supported by MariaDB.