On 21 Jan 07:50, Jonathan Lowery wrote:
Here are some patches that should allow to use python-sql with
Oracle DB:
- Add a flavor to not use AS:
https://python-sql.tryton.org/bug38
- Support numeric paramstyle:
https://python-sql.tryton.org/bug39
- Add limit style: rownum:
https://python-sql.tryton.org/bug40
For the double-quotes and quoted table/column, as far as I see (on
Oracle 11g XE) they are correctly supported. Indeed for what I
understand, if you don't quote table/column, Oracle convert the name to
upper case. So maybe you have all your table/column named in upper case
and are used to query without quote in lower case. I think we must keep
the quote everywhere as they ensure unambiguity.