DBIish imaginary API example

dbish.pl

use DBIish;

# RaiseError is default
my $dbh  = DBIish.connect('SQLite', :dbname<db.sqlite3>);
my $stmt = $dbh.prepare('SELECT (col1, col2) FROM t WHERE col3 = ?');
$stmt.execute(42);

# lazy iteration
for $stmt.all-rows -> @row {
    say @row.join(', ');
}

# p6ish interface
# no distinction between fetchrow_array and fetchrow_arrayref
$stmt.execute(23);
while $stmt.fetchrow -> @row {
    say @row.join(', ');
}