07 March 2008

Source code generator whose input is an SQL statement. LGPL

SPWrapper 0.9 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).