package MySchema::Sneaky;

use base qw/DBIx::Class/;


__PACKAGE__->load_components(qw/Core/);

__PACKAGE__->table("DUMMY"); # madness going on

# scalar ref to the sql statement
__PACKAGE__->result_source_instance->name(
\<<EOSQL);
(

    select foo, bar
    from baz
) 
EOSQL

__PACKAGE__->add_columns(
    qw/ foo bar /
);