Hello, I'm trying to access Phoenix using Microsoft Excel. I have written a very thin ODBC wrapper around Phoenix that I use to pass SQL from Microsoft Query to my ODBC (which just passes the SQL along) to Phoenix.
My problem is with case-insensitivity. All my column families/qualifiers are lowercase. I know I can just surround them with double quotes in my SQL statement and Phoenix will not auto-uppercase them. Unfortunately, I can't control exactly what Microsoft Query sends along to my ODBC. For example, if I have a column family of "a" and a column qualifier of "b" Microsoft Query will send: "a.b" When I really want: "a"."b" I have tried aliasing the column "a"."b" to A.B but as I understand it, Phoenix does not support aliasing in CREATE VIEW or CREATE TABLE. Is there a config setting in Phoenix that I can set to turn off auto-uppercase? If this setting does not exist, is this something I could contribute to the project? I understand I can modify my schema to be all uppercase or I could parse the SQL and fix it in my ODBC but I'm wondering if there is a Phoenix solution to this problem. Thank you for your time, - Alex
