script/stat_create.pl model DB DBIC::Schema DB::Schema create=static dbi:Pg:dbname=stat '' '' '{AutoCommit => 0}' #### |-- lib | |-- DB | | |-- Schema | | | |-- Class1.pm | | | |-- Class2.pm | | | |-- ... | | | `-- ClassN.pm | | `-- Schema.pm #### package DB::Schema::Add; use strict; use warnings; use base 'DBIx::Class::Core'; __PACKAGE__->table("NONE"); __PACKAGE__->add_columns(qw/number/); __PACKAGE__->result_source_instance ->name(\'(select 10*10 as number)'); 1; #### my ($res) = $c->model('Add')->all; my $number = $res->number; #### package DB::Schema::Add; use strict; use warnings; use base 'DBIx::Class::Core'; __PACKAGE__->table("NONE"); __PACKAGE__->add_columns(qw/number/); __PACKAGE__->result_source_instance ->name(\'(select ?::integer * ?::integer as number)'); 1; #### my ($res) = $c->model('Add')->search({}, {bind => [5, 7]}); my $body = $res->number;