dbix-perlish.tobez.org

Example code:

my $t : tab;
return "foo-$t->name-moo";

Perl code
Query type	select update delete
SQL flavor	Oracle PostgreSQL MySQL SQLite

You can enter your own query subs in the format understood by the DBIx::Perlish module, and see what will be the SQL generated by the module.

You are welcome to use the example code snippets above for inspiration. Clicking on the "example code" link will enter the example code into the text area.

You can adjust what kind of query it is, and what DBMS flavor you are using.

Please note that the query you type will get wrapped into an appropriate db_ function; this means that although the DBIx::Perlish module can deal with lexical variables from the outer scope, there is no way to define those using this interface.

Occasionally this script might barf on a query that DBIx::Perlish has no trouble dealing with. Most likely, this can be attributed to me being too paranoid with Safe.pm. I would appreciate if you report such ocurrences to me so that I can try and fix them. Thanks.