Changes for version 0.22 - 2008-02-24

  • A table that was passed to $sql->from($table) and also included in a join could show up in the FROM clause twice. Based on a patch from Dieter Pearcey.
  • Fey::Literal::Term now accepts a list of items which it joins together. These items can be strings or Fey objects like columns or tables. This makes generating arbitrary of SQL snippets easier. Based on a patch from Dieter Pearcey.

Modules

Fey
Better SQL Generation Through Perl
Represents a column
Represents an alias for a column
Defines exceptions used in the core Fey classes
Represents a foreign key
Just enough of the DBI API to fool Fey
Represents a literal piece of a SQL statement
Represents a literal function in a SQL statement
Represents a literal NULL in a SQL statement
Represents a literal number in a SQL statement
Represents a literal string in a SQL statement
Represents a literal term in a SQL statement
Holds a set of named objects
Represents a placeholder
A role for "column-like" behavior
A role for things that can be part of a WHERE clause
A role for things that can be part of a GROUP BY clause
A role for things that can be part of a JOIN BY clause
A role for things with a name
A role for things that can be part of a ORDER BY clause
A role for queries which can have bind parameters
A role for queries which can include a LIMIT clause
A role for queries which can include a ORDER BY clause
A role for queries which can include a WHERE clause
A role for things that can go in a SELECT clause
A role for things that are like a table
Documentation on SQL generation with Fey and SQL object factory
Represents a DELETE query
Represents a single join in a FROM clause
Represents a subselect
Represents an AND or OR in a WHERE clause
Represents a comparison in a WHERE clause
Represents the end of a subgroup in a WHERE clause
Represents the start of a subgroup in a WHERE clause
Represents a INSERT query
Represents a SELECT query
Represents a UPDATE query
Represents a "stand-alone" WHERE clause
Represents a schema and contains tables and foreign keys
Represents a table (or view)
Represents an alias for a table
Types for use in Fey