NAME
SQL::Abstract::Builder - Builds and executers relational queries
SYNOPSIS
my @docs = query {"dbi:mysql:$db",$user} build {
-columns => [qw(id foo bar)],
-from => 'table1',
-key => 'id',
} include {
-columns => [qw(id baz glarch)],
-from => 'table2',
-key => 'table1_id',
} include {
-columns => [qw(id alfa)],
-from => 'table3',
-key => 'table1_id',
};
DESCRIPTION
It gives you a very simple way to define fetch documents (rows and
related children) from your relational DB (instead of just rows).
METHODS
query
Executes the built query. Takes either a DBIx::Simple connection or the
same arguments that are valid for "DBIx::Simple-"connect>.
Usage
my @docs = query {"dbi:mysql:$db",$user} ...
# OR
my @docs = query {$dbh} ...
build
Builds the query assuming the given table is the base.
Usage
my @refs = build { ... } ...
include
Includes the results of a "JOIN" on the given table when built.
Usage
my @refs = build { ... } include { ... }
