SQL::Statement - SQL parsing and processing engine River stage two • 21 direct dependents • 81 total dependents

The SQL::Statement module implements a pure Perl SQL parsing and execution engine. While it by no means implements full ANSI standard, it does support many features including column and table aliases, built-in and user-defined functions, implicit and...

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Statement::RAM River stage two • 21 direct dependents • 81 total dependents

This package contains support for the internally used SQL::Statement::RAM::Table....

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Statement::Term - base class for all terms River stage two • 21 direct dependents • 81 total dependents

SQL::Statement::Term is an abstract base class providing the interface for all terms....

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Exec::Statement - Prepared statements support for SQL::Exec River stage zero No dependents

MATHIAS/SQL-Exec-0.10 - 27 Mar 2013 21:47:35 GMT

SQL::Statement::GetInfo River stage two • 21 direct dependents • 81 total dependents

This package contains support for "$dbh-"get_info()>....

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Statement::Functions - built-in & user-defined SQL functions River stage two • 21 direct dependents • 81 total dependents

This module contains the built-in functions for SQL::Parser and SQL::Statement. All of the functions are also available in any DBDs that subclass those modules (e.g. DBD::CSV, DBD::DBM, DBD::File, DBD::AnyData, DBD::Excel, etc.). This documentation c...

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Statement::Util River stage two • 21 direct dependents • 81 total dependents

This package contains three utility classes to handle deliverable columns....

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Statement::TermFactory - Factory for SQL::Statement::Term instances River stage two • 21 direct dependents • 81 total dependents

This package implements a factory to create type and operation based terms. Those terms are used to access data from the table(s) - either when evaluating the where clause or returning column data. The concept of a factory can be studied in *Design P...

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Statement::Placeholder - implements getting the next placeholder value River stage two • 21 direct dependents • 81 total dependents

SQL::Statement::Placeholder implements getting the next placeholder value. Accessing a specific placeholder is currently unimplemented and not tested....

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Statement::Operation - base class for all operation terms River stage two • 21 direct dependents • 81 total dependents

SQL::Statement::Operation is an abstract base class providing the interface for all operation terms....

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Statement::Function - abstract base class for all function executing terms River stage two • 21 direct dependents • 81 total dependents

SQL::Statement::Function is an abstract base class providing the interface for all function executing terms....

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

Bundle::Test::SQL::Statement - Requirement Bundle to allow wider tests of SQL::Statement River stage zero No dependents

This module requires almost everything what could be used by SQL::Statement to run more test cases....

REHSACK/Bundle-Test-SQL-Statement-1.33 - 05 Feb 2011 14:14:34 GMT

SQL::Statement::Functions::Date - More date/time functions River stage zero No dependents

This distribution contains several SQL functions to be used with SQL::Statement: YEAR() MONTH() DAYOFYEAR() DAYOFMONTH() DAY() WEEKOFYEAR() WEEKDAY() They are based on MySQL's version. More functions wil be added as needed. To use a function from Per...

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

SQL::Statement::Functions::Logic - Logic functions River stage zero No dependents

This distribution contains several SQL functions to be used with SQL::Statement: IF() To use a function from Perl script: require SQL::Statement::Function::ByName::IF; $dbh->do(qq{CREATE FUNCTION IF NAME "SQL::Statement::Function::ByName::MAXNUM::SQL...

PERLANCAR/SQL-Statement-Functions-Logic-0.001 - 25 Jan 2017 06:33:35 GMT

SQL::Statement::Functions::ArgMinMax - ARGMIN*/ARGMAX* functions River stage zero No dependents

This distribution contains several SQL functions to be used with SQL::Statement: ARGMAXNUM() ARGMAXSTR() ARGMINNUM() ARGMINSTR() These functions are not aggregate functions. They are added due to the lack of CASE statement as well as IF function in S...

PERLANCAR/SQL-Statement-Functions-ArgMinMax-0.002 - 25 Jan 2017 06:33:30 GMT

SQL::Eval - Base for deriving evaluation objects for SQL::Statement River stage two • 21 direct dependents • 81 total dependents

This module implements two classes that can be used for deriving subclasses to evaluate SQL::Statement objects. The SQL::Eval object can be thought as an abstract state engine for executing SQL queries and the SQL::Eval::Table object is a table abstr...

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Parser - validate and parse SQL strings River stage two • 21 direct dependents • 81 total dependents

SQL::Parser is part of the SQL::Statement distribution and, most interaction with the parser should be done through SQL::Statement. The methods shown above create and modify a parser object. To use the parser object to parse SQL and to examine the re...

REHSACK/SQL-Statement-1.412 - 06 Apr 2017 12:48:54 GMT

SQL::Statement::Function::ByName::IF - SQL function to return a value or the other depending on condition River stage zero No dependents

Caveat: the notion of true and false follows Perl's notion. Caveat: due to the current limitation of SQL::Parser, this function is not as useful as it should be, e.g. SQL::Parser cannot parse this correctly: SELECT IF(col > 10, a, b) FROM table...

PERLANCAR/SQL-Statement-Functions-Logic-0.001 - 25 Jan 2017 06:33:35 GMT

SQL::Statement::Function::ByName::DAY - DAY() SQL function River stage zero No dependents

Implements DAY() SQL function. It is synonym for DAYOFMONTH()....

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

SQL::Statement::Function::ByName::YEAR - YEAR() SQL function River stage zero No dependents

Implements YEAR() SQL function. Syntax: YEAR(date) Return integer (e.g. 2015), or undef if argument is not detected as date....

PERLANCAR/SQL-Statement-Functions-Date-0.04 - 25 Jan 2017 06:33:32 GMT

149 results (0.031 seconds)