Re: [sqlalchemy] custom Python functions as part of SQL queries

2011-06-01 Thread Michael Bayer
As discussed on IRC, for those reading the list, the difference here is between SQLite's ability to embed native functions (and in turn Pysqlite's ability to use Python functions in this way), and other databases that don't run as embedded libraries. The functions need to be expressed as SQL

[sqlalchemy] custom Python functions as part of SQL queries

2011-06-01 Thread Tom Kralidis
Hi, I'm using SQLAlchemy 0.6.6 for a web application. At this point, the app uses SQLite3 as the underlying database; I'm currently working on abstracting this out to work with others (PostgreSQL, MySQL). At a high level, the application receives CGI queries which are parsed and sent to SQLAlche