SQL::Abstract - Generate SQL from Perl data structures River stage three • 69 direct dependents • 626 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.86 - 09 Jul 2018 16:32:08 GMT

SQL::Abstract::Pg - PostgreSQL River stage two • 13 direct dependents • 15 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.13 - 20 Jan 2019 22:34:18 GMT

DBIx::SQL::Abstract - Provides a convenient abstraction layer to a database. River stage one • 1 direct dependent • 1 total dependent

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 GMT

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

ILMARI/SQL-Abstract-1.86 - 09 Jul 2018 16:32:08 GMT

SQL::Abstract::More - extension of SQL::Abstract with more constructs and more flexible API River stage two • 8 direct dependents • 11 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 GMT

SQL::Abstract::Test - Helper function for testing SQL::Abstract River stage three • 69 direct dependents • 626 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.86 - 09 Jul 2018 16:32:08 GMT

SQL::Abstract::Limit - portable LIMIT emulation River stage two • 7 direct dependents • 34 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 GMT

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....

TEKKI/Mojo-mysql-1.15 - 22 Apr 2019 07:31:39 GMT

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 GMT

SQL::Abstract::Complete - Generate complete SQL from Perl data structures River stage one • 3 direct dependents • 3 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 GMT

SQL::Abstract::Prefetch - implement "prefetch" for DBI RDBMS No river data available

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 GMT

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

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 GMT

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

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 GMT

SQL::Abstract::FromQuery::Oracle - SQL::Abstract::FromQuery extension for Oracle queries River stage one • 2 direct dependents • 2 total dependents

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 GMT

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

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 GMT

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

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 GMT

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 GMT

lib/Query/Abstract/Driver/SQL.pm River stage one • 1 direct dependent • 3 total dependents

KOORCHIK/Query-Abstract-0.01 - 17 Mar 2015 11:04:46 GMT

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

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

DBIx::OO - Database to Perl objects abstraction River stage one • 1 direct dependent • 1 total dependent

This module has been inspired by the wonderful Class::DBI. It is a database-to-Perl-Objects abstraction layer, allowing you to interact with a database using common Perl syntax. Why another Class::DBI "clone"? 1 I had the feeling that Class::DBI is n...

MISHOO/DBIx-OO-0.0.9 - 26 Nov 2008 10:10:27 GMT

57 results (0.047 seconds)