SQL::Abstract - Generate SQL from Perl data structures River stage three • 73 direct dependents • 657 total dependents

This module was inspired by the excellent DBIx::Abstract. However, in using that module I found that what I really wanted to do was generate SQL, but still retain complete control over my statement handles and use the DBI interface. So, I set out to ...

ILMARI/SQL-Abstract-1.87 - 02 Jun 2020 10:37:19 UTC

SQL::Abstract::Pg - PostgreSQL River stage two • 14 direct dependents • 16 total dependents

SQL::Abstract::Pg extends SQL::Abstract with a few PostgreSQL features used by Mojo::Pg. JSON In many places (as supported by SQL::Abstract) you can use the "-json" unary op to encode JSON from Perl data structures. # "update some_table set foo = '[1...

SRI/Mojo-Pg-4.20 - 02 Oct 2020 11:03:20 UTC

DBIx::SQL::Abstract - Provides a convenient abstraction layer to a database. River stage zero No dependents

The intention of this module is to join some methods from the DBI and the SQL::Abstract modules, for a convenient and easy use. To begin, we create an object, but first we must create a hash which contains the database parameters as follows. my %dbcf...

ALECS/DBIx-SQL-Abstract-0.07 - 12 Sep 2005 18:09:31 UTC

SQL::Abstract::Tree - Represent SQL as an AST River stage three • 73 direct dependents • 657 total dependents

ILMARI/SQL-Abstract-1.87 - 02 Jun 2020 10:37:19 UTC

SQL::Abstract::Test - Helper function for testing SQL::Abstract River stage three • 73 direct dependents • 657 total dependents

This module is only intended for authors of tests on SQL::Abstract and related modules; it exports functions for comparing two SQL statements and their bound values. The SQL comparison is performed on *abstract syntax*, ignoring differences in spaces...

ILMARI/SQL-Abstract-1.87 - 02 Jun 2020 10:37:19 UTC

SQL::Abstract::Util - Small collection of utilities for SQL::Abstract::Classic River stage three • 1 direct dependent • 508 total dependents

RIBASUSHI/SQL-Abstract-Classic-1.91 - 17 Oct 2019 10:29:44 UTC

SQL::Abstract::More - extension of SQL::Abstract with more constructs and more flexible API River stage two • 7 direct dependents • 10 total dependents

Generates SQL from Perl data structures. This is a subclass of SQL::Abstract, fully compatible with the parent class, but with some improvements : * methods take arguments as *named parameters* instead of positional parameters. This is more flexible ...

DAMI/SQL-Abstract-More-1.33 - 14 Jan 2018 21:11:37 UTC

SQL::Abstract::mysql - Generate SQL from Perl data structures for MySQL and MariaDB River stage one • 3 direct dependents • 5 total dependents

SQL::Abstract::mysql extends SQL::Abstract with a few MySQL / MariaDB features used by Mojo::mysql. It was inspired by SQL::Abstract::Pg....

JHTHORSEN/Mojo-mysql-1.20 - 05 Sep 2020 04:28:19 UTC

SQL::Abstract::Limit - portable LIMIT emulation River stage three • 7 direct dependents • 540 total dependents

Portability layer for LIMIT emulation. new( case => 'lower', cmp => 'like', logic => 'and', convert => 'upper', limit_dialect => 'Top' ) All settings are optional. limit_dialect Sets the default syntax model to use for emulating a "LIMIT $rows OFFSET...

DAVEBAIRD/SQL-Abstract-Limit-0.141 - 22 Dec 2008 21:15:40 UTC

SQL::Abstract::Builder - Builds and executers relational queries River stage zero No dependents

It gives you a very simple way to define fetch documents (rows and related children) from your relational DB (instead of just rows)....

TRON/SQL-Abstract-Builder-v0.1.1 - 26 Apr 2012 20:19:29 UTC

SQL::Abstract::Classic - Generate SQL from Perl data structures River stage three • 1 direct dependent • 508 total dependents

This module was inspired by the excellent DBIx::Abstract. However, in using that module I found that what I really wanted to do was generate SQL, but still retain complete control over my statement handles and use the DBI interface. So, I set out to ...

RIBASUSHI/SQL-Abstract-Classic-1.91 - 17 Oct 2019 10:29:44 UTC

SQL::Abstract::Complete - Generate complete SQL from Perl data structures River stage one • 2 direct dependents • 2 total dependents

This module was inspired by the excellent SQL::Abstract, from which in inherits. However, in trying to use the module, I found that what I really wanted to do was generate complete SELECT statements including joins and group by clauses. So, I set out...

GRYPHON/SQL-Abstract-Complete-1.06 - 29 Jan 2015 23:49:35 UTC

SQL::Abstract::Prefetch - implement "prefetch" for DBI RDBMS River stage zero No dependents

This class implements "prefetch" in the style of DBIx::Class. Stages of operation: * Generate a "query spec" that describes what you want back from the database - which fields from which tables, and what relations to join. * Generate SQL (and bind pa...

ETJ/SQL-Abstract-Prefetch-0.003 - 11 Apr 2019 04:11:46 UTC

SQL::Abstract::FromQuery - Translating an HTTP Query into SQL::Abstract structure River stage one • 1 direct dependent • 1 total dependent

This module is intended to help building Web applications with complex search forms. It translates user input, as obtained from an HTML form, into a datastructure suitable as a %where clause for the SQL::Abstract module; that module will in turn prod...

DAMI/SQL-Abstract-FromQuery-0.10 - 06 Apr 2015 19:20:47 UTC

SQL::Abstract::FromQuery::FR - SQL::Abstract::FromQuery extension for French dates and times River stage one • 1 direct dependent • 1 total dependent

This subclass extends the SQL::Abstract::FromQuery grammar for accepting keywords in french (like 'ENTRE', 'VRAI', 'FAUX', 'NUL')....

DAMI/SQL-Abstract-FromQuery-0.10 - 06 Apr 2015 19:20:47 UTC

SQL::Abstract::FromQuery::Oracle - SQL::Abstract::FromQuery extension for Oracle queries River stage one • 1 direct dependent • 1 total dependent

This subclass automatically adds Oracle "TO_DATE(...)" conversions in SQL generated from date and time fields....

DAMI/SQL-Abstract-FromQuery-0.10 - 06 Apr 2015 19:20:47 UTC

SQL::Abstract::FromQuery::Contains - SQL::Abstract::FromQuery extension for a 'contains' rule River stage one • 1 direct dependent • 1 total dependent

This component adds rules "contains" and "contains_any" to the root grammar. The purpose is to generate fulltext queries to the database on some specific fields. Fields associated to such rules will generate structures of shape {-contains => $list_of...

DAMI/SQL-Abstract-FromQuery-0.10 - 06 Apr 2015 19:20:47 UTC

SQL::Abstract::Plugin::InsertMulti - add mysql bulk insert supports for SQL::Abstract River stage one • 1 direct dependent • 1 total dependent

SQL::Abstract::Plugin::InsertMulti is enable bulk insert support for SQL::Abstract. Declare 'use SQL::Abstract::Plugin::InsertMulti;' with 'use SQL::Abstract;', exporting insert_multi() and update_multi() methods to SQL::Abstract namespace from SQL::...

ZIGOROU/SQL-Abstract-Plugin-InsertMulti-0.05 - 05 Nov 2018 06:44:30 UTC

lib/SQL/Abstract/Plugin/InsertReturning.pm River stage zero No dependents

DEPRECATED. This functionality is now in SQL::Abstract itself. This module just wraps around that. Please, stop using this! Some databases have support for returning data after an insert query, which can help gain performance when doing common operat...

CYCLES/SQL-Abstract-Plugin-InsertReturning-0.05 - 11 Mar 2010 00:06:19 UTC

lib/CellBIS/SQL/Abstract.pm River stage zero No dependents

YUSRIDEB/CellBIS-SQL-Abstract-1.2 - 20 Aug 2018 20:50:12 UTC

69 results (0.056 seconds)