SQL-Statement

Changes for version 1.412 - 2017-04-06

Release 1.411_001 without further changes as 1.412

Changes for version 1.411_001 - 2017-03-30

Bug fixes
- Fix http://www.perlmonks.org/?node_id=1167381 (NumericEval: fix typo on error handling) (thanks to Yanick Champoux, James R. Leu)
- fix repo url and t/02execute.t (Reini Urban, Mohammad S Anwar)
- fix test failing with blead-perl (Jens Rehsack)
Improvements
- Refactor constraints processing (Ovidiu Gheorghies)
- Support parsing of complex JOIN clause (containing OR and ()'s) (James R. Leu)
- handle backtick quoting (Ben Hengst)

Documentation

SQL::Statement::Embed

embed a SQL engine in a DBD or module

SQL::Statement::Roadmap

Planned Enhancements for SQL::Statement and SQL::Parser

SQL::Statement::Structure

parse and examine structure of SQL queries

SQL::Statement::Syntax

documentation of SQL::Statement's SQL Syntax

Modules

SQL::Dialects::ANSI

SQL::Dialects::AnyData

SQL::Dialects::CSV

SQL::Dialects::Role

The role of being a SQL::Dialect

SQL::Eval

Base for deriving evaluation objects for SQL::Statement

SQL::Parser

validate and parse SQL strings

SQL::Statement

SQL parsing and processing engine

SQL::Statement::Function

abstract base class for all function executing terms

SQL::Statement::Functions

built-in & user-defined SQL functions

SQL::Statement::GetInfo

SQL::Statement::Operation

base class for all operation terms

SQL::Statement::Placeholder

implements getting the next placeholder value

SQL::Statement::RAM

SQL::Statement::Term

base class for all terms

SQL::Statement::TermFactory

Factory for SQL::Statement::Term instances

SQL::Statement::Util

Provides

SQL::Eval::Table

in lib/SQL/Eval.pm

SQL::Statement::Aggregate

in lib/SQL/Statement.pm

SQL::Statement::ColumnValue

in lib/SQL/Statement/Term.pm

SQL::Statement::ConstantTerm

in lib/SQL/Statement/Term.pm

SQL::Statement::Function::NumericEval

in lib/SQL/Statement/Function.pm

SQL::Statement::Function::StrConcat

in lib/SQL/Statement/Function.pm

SQL::Statement::Function::SubString

in lib/SQL/Statement/Function.pm

SQL::Statement::Function::Trim

in lib/SQL/Statement/Function.pm

SQL::Statement::Function::UserFunc

in lib/SQL/Statement/Function.pm

SQL::Statement::Group

in lib/SQL/Statement.pm

SQL::Statement::Limit

in lib/SQL/Statement.pm

SQL::Statement::Operation::ANSI::Is