SQLizer is a utility library intended to be used in search applications. Given an input string, it builds an SQL select statement. It supports two types of input: numeric and string. The catch is that this library allows usage of operators in the input string. Supported operators are "and", "or", "not", and grouping by means of parentheses. It also supports the wildcards "*", "%", "?", and "_" in string searches as well as regular expressions enclosed in /.../.
SPWrapper is a source code generator whose input is an SQL statement, or with some limitations the name of a stored procedure. Each SQL statement become a Java class, iterable to fetch results if the statement is a SELECT. It is possible to generate Python classes for the cx_Oracle module. SPWrapper is designed to require little configuration: it tries to automatically guess input parameters form SQL code, and output parameters from the SQL result set fetched. All the SQL statements can be translated to source code, even those with proprietary syntax. It currently supports 4 databases for Java (Oracle, PostgreSQL, MySQL and SQL Server) and Oracle with Python. A Netbeans plugin is also available (for stored procedures only).
pyswarm is planned as a holistic set of tools (especially a code generator) for model-driven software development (MDSD) of database-backed Web applications. It provides easily customizable business logic based on Python and PostgreSQL. As required by the MDA standard, pyswarm uses UML (version 2.0 stored as XMI 2.1).
LiteSQL is a C++ library that integrates C++ objects tightly to a relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL, and MySQL as backends. LiteSQL creates tables, indexes, and sequences to database and upgrades schema when needed. In addition to object persistence, LiteSQL provides object relations which can be used to model any kind of C++ data structures. Objects can be selected, filtered, and ordered using a template- and class-based API with type checking at compile time.
XML to DDL is a set of Python programs that converts an XML representation of a database into a set of SQL or DDL (Data Definition Language) commands. In addition, it can examine the difference between two XML files and output a sequence of SQL statements (normally ALTER statements) to bring one database up-to-date with the XML schema. You can also download the XML schema directly from the database. Finally, there's a tool to convert your schema into HTML for documentation purposes. XML to DDL currently supports the most recent versions of PostgreSQL, MySQL, Oracle, and Firebird databases.
Cordova is a solution to source code and database schema generation. Its focus is on MySQL, Java, and OJB. It provides tools and plugins to assist in operations of the database, compilation of code, and code generation. Each module has been created out of need, where no tool has cleanly existed before. Its direction is towards 2 modes: an ANT task, and command line without ANT dependencies.