The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

Changes for version 0.25 - 2008-04-01

  • Major internals changes to how aliasable things are created and used. Added two new roles, Fey::Role::MakesAliasObjects, and Fey::Role::HasAliasName. All literals can now be aliased (including Terms). A subselect is now just a Fey::SQL::Select object internally, which makes the internals much cleaner. This also means that a Fey::SQL::Select has an ->alias_name. Implemented by Dieter Pearcey.
  • Added support for "NULLS FIRST/LAST" in ORDER BY clauses. Implemented by Erik Rijkers. RT #44656.

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 objects that bring an alias with them
A role for things that can be part of a JOIN BY clause
A role for objects with separate alias objects
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 a set operation
A role for things that are like a table
Documentation on SQL generation with Fey and SQL object factory
Represents a DELETE query
Represents an EXCEPT operation
Represents a single join in a FROM clause
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 an INTERSECT operation
Represents a SELECT query
Represents a UNION operation
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