Fey Better SQL Generation Through Perl
Download

Fey Ranking & Summary

Fey Tags

SQL Perl module perl Generation SQL generation

Fey Description

Better SQL Generation Through Perl Fey offers better SQL generation through Perl.SYNOPSIS use Fey::Literal::Function; use Fey::Placeholder; use Fey::Schema; use Fey::SQL; my $schema = hand_waving(); my $user = $schema->table('User'); my $group = $schema->table('Group') my $select = Fey::SQL->new_select(); my $func = Fey::Literal::Function->new( 'LCASE', $user->column('username') ); $select->select( $user->columns( 'user_id', 'username' ) ) ->from( $user, $group ) ->where( $group->group_id, 'IN', 1, 2, 3 ) ->and ( $func, 'LIKE', 'smith%' ); print $select->sql($dbh);The Fey distribution contains a set of modules for representing the components of a DBMS schema, and for dynamically generating SQL queries based on that schema. Requirements: · Perl

Fey Related Software