SQL::Abstract - Generate SQL from Perl data structures River stage three • 65 direct dependents • 588 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 ...

MSTROUT/SQL-Abstract-2.000001 - 23 Jan 2021 07:24:31 UTC

SQL::Abstract::Pg - PostgreSQL features for SQL::Abstract River stage two • 3 direct dependents • 33 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/SQL-Abstract-Pg-1.0 - 20 Feb 2021 16:53:26 UTC

SQL::Abstract::Test - Helper function for testing SQL::Abstract River stage three • 65 direct dependents • 588 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...

MSTROUT/SQL-Abstract-2.000001 - 23 Jan 2021 07:24:31 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::More - extension of SQL::Abstract with more constructs and more flexible API River stage one • 6 direct dependents • 7 total dependents

This module generates SQL from Perl data structures. It is a subclass of SQL::Abstract or SQL::Abstract::Classic, fully compatible with the parent class, but with some improvements : * methods take arguments as *named parameters* instead of positiona...

DAMI/SQL-Abstract-More-1.37 - 29 Jan 2021 20:54:54 UTC

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

MSTROUT/SQL-Abstract-2.000001 - 23 Jan 2021 07:24:31 UTC

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

RIBASUSHI/SQL-Abstract-Classic-1.91 - 17 Oct 2019 10:29:44 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.25 - 22 Nov 2021 09:14:39 UTC

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

ASB/SQL-Abstract-Limit-0.143 - 28 Mar 2021 19:25:37 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 • 442 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::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::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.07 - 10 Jan 2021 22:19:22 UTC

SQL::Abstract::Reference - Reference documentation for SQL::Abstract River stage three • 65 direct dependents • 588 total dependents

MSTROUT/SQL-Abstract-2.000001 - 23 Jan 2021 07:24:31 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.11 - 03 Feb 2021 23:38:47 UTC

SQL::Abstract::Role::Plugin - helpful methods for plugin authors River stage three • 65 direct dependents • 588 total dependents

MSTROUT/SQL-Abstract-2.000001 - 23 Jan 2021 07:24:31 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.11 - 03 Feb 2021 23:38:47 UTC

CellBIS::SQL::Abstract::Test - A part of Unit Testing River stage zero No dependents

This module is only a test instrument in SQLite, Mariadb, and PostgreSQL...

YUSRIDEB/CellBIS-SQL-Abstract-1.5 - 08 Apr 2021 21:32:00 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.11 - 03 Feb 2021 23:38: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
78 results (0.05 seconds)