QAL 0.4.0

QAL (Query Abstraction Layer) is a set of Python libraries to handle and interchange data between multiple SQL databases or file storage backends. It works with Postgres, MySQL, DB2, Oracle and MS SQL server, and can read/write XML, CSV and Excel. It defines a SQL subset to facilitate interoperability.

Tags python database sql csv
License BSDL
State stable

Recent Releases

0.4.030 Oct 2014 12:05 minor bugfix: Add support for importing data without keys. Add support for importing data and automatically create destination table. Add test for Post-execute-SQL. Make meta query function static methods. Improve documentation. Cleanup. Change default sql type for python type "datetime" to "datetime". For some reason this was "timestamp" earlier, which is a data type that updates when records change on MySQL which makes it untestable.