Use DBIx::Simple instead of Dancer::Plugin::Database's normal methods:


    use Dancer::Plugin::Database;
    use DBIx::Simple;
    sub query {DBIx::Simple->new(database())->iquery(@_)}

    # example usage
    my %results = query('SELECT id, last_name FROM some_table WHERE first_name = ', \$first-name)->flat;