Search results for "module:SQL::Statement"
SQL::Statement - SQL parsing and processing engine
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.414 - 21 Oct 2020 14:46:55 UTC
SQL::Statement::RAM
This package contains support for the internally used SQL::Statement::RAM::Table....
REHSACK/SQL-Statement-1.414 - 21 Oct 2020 14:46:55 UTC
SQL::Statement::Term - base class for all terms
SQL::Statement::Term is an abstract base class providing the interface for all terms....
REHSACK/SQL-Statement-1.414 - 21 Oct 2020 14:46:55 UTC
SQL::Exec::Statement - Prepared statements support for SQL::Exec
MATHIAS/SQL-Exec-0.10
-
27 Mar 2013 21:47:35 UTC
SQL::Statement::GetInfo
This package contains support for "$dbh-"get_info()>....
REHSACK/SQL-Statement-1.414 - 21 Oct 2020 14:46:55 UTC
SQL::Statement::Functions - built-in & user-defined SQL functions
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.414 - 21 Oct 2020 14:46:55 UTC
SQL::Statement::Util
This package contains three utility classes to handle deliverable columns....
REHSACK/SQL-Statement-1.414 - 21 Oct 2020 14:46:55 UTC
SQL::Statement::Operation - base class for all operation terms
SQL::Statement::Operation is an abstract base class providing the interface for all operation terms....
REHSACK/SQL-Statement-1.414 - 21 Oct 2020 14:46:55 UTC
SQL::Statement::TermFactory - Factory for SQL::Statement::Term instances
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.414 - 21 Oct 2020 14:46:55 UTC
SQL::Statement::Placeholder - implements getting the next placeholder value
SQL::Statement::Placeholder implements getting the next placeholder value. Accessing a specific placeholder is currently unimplemented and not tested....
REHSACK/SQL-Statement-1.414 - 21 Oct 2020 14:46:55 UTC
SQL::Statement::Function - abstract base class for all function executing terms
SQL::Statement::Function is an abstract base class providing the interface for all function executing terms....
REHSACK/SQL-Statement-1.414 - 21 Oct 2020 14:46:55 UTC
Bundle::Test::SQL::Statement - Requirement Bundle to allow wider tests of SQL::Statement
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 UTC
SQL::Statement::Functions::Date - More date/time functions
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.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Functions::Logic - Logic functions
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 UTC
SQL::Statement::Functions::ArgMinMax - ARGMIN*/ARGMAX* functions
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 UTC
SQL::Eval - Base for deriving evaluation objects for SQL::Statement
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.414 - 21 Oct 2020 14:46:55 UTC
SQL::Parser - validate and parse SQL strings
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.414 - 21 Oct 2020 14:46:55 UTC
SQL::Statement::Function::ByName::IF - SQL function to return a value or the other depending on condition
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 UTC
SQL::Statement::Function::ByName::DAY - Synonym for DAYOFMONTH() SQL function
Implements DAY() SQL function. It is synonym for DAYOFMONTH()....
PERLANCAR/SQL-Statement-Functions-Date-0.050 - 24 Dec 2022 00:05:27 UTC
SQL::Statement::Function::ByName::DATE - Return the date part (e.g. 2022-12-13) of a date/datetime expression
Implements DATE() SQL function to return the date part, like in MySQL. Syntax: DATE(date) Return "2022-12-13", or undef if argument is not detected as date....
PERLANCAR/SQL-Statement-Functions-Date-0.050 - 24 Dec 2022 00:05:27 UTC