xplain2sql
xplain2sql converts files from Xplain to SQL. It supports a very large subset of Xplain, and it can convert from Xplain to Microsoft SQL Server, DB/2, Inprise InterBase, PostgreSQL, Oracle, MySQL 5, SQLite 3 or ANSI-92 SQL. It can also generate an XML description of the generated SQL. This XML description can be used to create low-level middle-tier code. Example stylesheets for Eiffel/ECLI and Delphi/ADO are included. The C source code release should compile on any platform with an ANSI C compiler. There are binary releases for FreeBSD, Linux, Solaris x86, and Windows 2000.
| Tags | Database Front-Ends Software Development Code Generators |
|---|---|
| Licenses | EFL |
| Operating Systems | BeOS POSIX Windows Windows Windows Windows Linux BSD FreeBSD |
| Implementation | Eiffel |
Recent releases
- 19 Aug 2008 00:25
Changes: Much better code generation for the count, min, max, and total functions using left outer joins instead of sub-selects. A new extension to mimic SQL's insert into ... select. Extended attributes can now be updated for most dialects. A variety of bugfixes. Now includes an Ubuntu 8.0.4 package.
- 02 Mar 2007 00:21
Changes: Assert support was added. If-then-else is supported in init [default] statements for dialects that support triggers.
- 21 Jun 2006 12:57
Changes: More faithful support for init [default] expressions. PostgreSQL output when using values in a stored procedure has been fixed. MySQL 5 support has been added. Support for SQLite 3 has been added. Any and nil support are now correctly implemented for InterBase 6. Functions like min and max now work as expected on InterBase 6.
- 01 Dec 2005 23:52
Changes: MySQL 5 and SQLite support was added. Complete support was added for init and init default for most dialects. InterBase 6 improvements were done.
- 28 Feb 2005 17:18
Changes: Column number is now reported for warnings. Values can now be updated (previously, this worked only for certain dialects). Support has been added for the * and ? operators. If these two characters appear in a literal string, the comparison is done with like. Bugfixes for output for InterBase, PostgreSQL, Microsoft SQL and Oracle.
