Re: [sqlalchemy] Syntax error from sqlalchemy generated sql to sybase ase

2018-11-28 Thread Ken MacKenzie
That makes sense, and as much as I would volunteer to try to maintain the dialect, I can't see justify using work resources (where I have access to Sybase) to maintain an open source component for a DB we are working to migrate away from. Since the metadata is collecting ok, minus some type

Re: [sqlalchemy] Syntax error from sqlalchemy generated sql to sybase ase

2018-11-28 Thread Mike Bayer
Hi there - Unfortuantely, the Sybase dialect is unmaintained and will likely be removed from a future SQLAlchemy release.For this database to be usable, a dedicated maintainer would need to volunteer and we can set them up with a new sybase ASE dialect available as a third party download.

[sqlalchemy] Syntax error from sqlalchemy generated sql to sybase ase

2018-11-28 Thread Ken MacKenzie
Error message: sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000', "[42000] [FreeTDS][SQL Server]Incorrect syntax near 'dbo.APPLICATION_STATUS_DIM.'.\n (102) (SQLExecDirectW)") [SQL: 'SELECT dbo."APPLICATION_STATUS_DIM"."APPLICATION_STATUS_SKEY" AS

Re: [sqlalchemy] JSON Support for mssql 2016

2018-11-28 Thread Mike Bayer
OK, take a look at that SQLite commit, where someone else added the exact same thing for SQLite: https://github.com/sqlalchemy/sqlalchemy/commit/62d59088dfe86d7ecabd85ad626ee108b668acc5 the feature for SQL server would look similar, although I've taken a look at

[sqlalchemy] JSON Support for mssql 2016

2018-11-28 Thread sanjeev kumar
I was looking for sql expression support but i didn’t find anything,so random thought came why can’t contribute to. So if u give me any idea, to start things it will be very great -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example

Re: [sqlalchemy] JSON Support for mssql 2016

2018-11-28 Thread Mike Bayer
this can be contributed. the basic idea can be emulated from the SQLite version of the type, given in this change: https://github.com/sqlalchemy/sqlalchemy/commit/62d59088dfe86d7ecabd85ad626ee108b668acc5 note the main reason you'd want to make a JSON type is because you need the SQL expression

[sqlalchemy] JSON Support for mssql 2016

2018-11-28 Thread sanjeev kumar
Do sqlalchemy have support for MSsql 2016 JSON type.Or any project is going on for same,if any how i can contribute to that project. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal,