/ 
SQLx-Lite-3.0.5_001
/ SQLx::Lite::ResultSet

NAME

SQLx::Lite::ResultSet - Methods for searching and altering tables

primary_key

Sets the primary key for the current ResultSet

$rs->primary_key('id');

Access to the SQL SELECT query. Returns an array with the selected rows, which contains a hashref of values. First parameter is an array of what you want returned ie: SELECT this, that If you enter an empty array ([]), then it will return everything ie: SELECT * The second parameter is a hash of keys and values of what to search for.

my $res = $resultset->search([qw/name id status/], { status => 'active' });

my $res = $resultset->search([], { status => 'disabled' });