The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
 / 
SQL-Builder-0.03
++

Changes for version 0.03 - 2005-11-02

  • Added make_instance() factory to Base.pm
  • Added a test for make_instance() to Function.t
  • Removed Alias*.pm and Alias.t. Not being used and poorly done
  • Added documentation all over
  • Added better quoting support to Column.pm - now includes check for dbh() and falls back to quoter(), allows control of quoting mechanisms using various options. Also changed other() to use SQL::Builder::List instead of a Perl array. Added more tests
  • Modified Base.pm macro api to include mark_parents
  • Added placeholders
  • Extracted part of API from Base to AnyObject
  • Added children() method and documentation everywhere possible
  • Added better quoting support to Table.pm
  • Added tests for Select among otherss
  • Added alias_sql() to Base.pm

Modules

SQL::Builder
a structured SQL manipulation interface
SQL::Builder::AggregateFunction
A class for adding statefulness to aggregate SQL functions
SQL::Builder::Base
The base class for SQL::Builder objects
SQL::Builder::BinaryOp
Represent binary expressions (two or more operands)
SQL::Builder::Column
Represents a SQL table column
SQL::Builder::ColumnList
generate a list of expressions to be used in a SELECT statement's column list
SQL::Builder::Distinct
Object representation of a SELECT column list with support for DISTINCT/DISTINCT ON
SQL::Builder::Except
Object representation of the SQL "EXCEPT" junction
SQL::Builder::FromList
Represent the joins and tables in SQL's FROM clause
SQL::Builder::FromTable
Represents a table used in the SQL FROM clause
SQL::Builder::Function
represent a SQL function
SQL::Builder::GroupBy
Manage the list of expressions in a SQL's GROUP BY clause
SQL::Builder::Having
Represent SQL's HAVING clause
SQL::Builder::In
Represent the SQL IN operator
SQL::Builder::Intersect
Represent a SQL 'INTERSECT' junction
SQL::Builder::Join
Represent a SQL JOIN statement
SQL::Builder::JoinGroup
Represent a group of JOINs
SQL::Builder::Junction
Represent a SQL junction, typically including INTERSECT, UNION, and EXCEPT
SQL::Builder::Limit
Represent LIMIT/OFFSET clauses
SQL::Builder::List
An object interface for various SQL lists
SQL::Builder::Order
Represent an expression in SQL ORDER BY clauses
SQL::Builder::OrderBy
An object representation of the ORDER BY clause
SQL::Builder::Placeholder
Represent a DBI placeholder in a SQL::Builder tree
SQL::Builder::PostfixOp
Represent a SQL unary (postfix) operator/expression
SQL::Builder::PrefixOp
Represent a SQL unary (prefix) operator/expression
SQL::Builder::Select
Represent a SQL SELECT statement
SQL::Builder::Table
Represent a SQL table syntax
SQL::Builder::Text
represent values to be quoted in SQL
SQL::Builder::UnaryOp
Represent a SQL unary operator/expression
SQL::Builder::Union
Object representation of the SQL "UNION" junction
SQL::Builder::Where
Represent a SQL WHERE clause

Provides

SQL::Builder::AnyObject
in lib/SQL/Builder/AnyObject.pm
SQL::Builder::Iterator
in lib/SQL/Builder/Iterator.pm
SQL::Builder::Using
in lib/SQL/Builder/Using.pm

Other files