#!/usr/bin/perl
use warnings;
use strict;
use feature qw{ say };

use DBI;

my $db = 'DBI'->connect('dbi:SQLite:dbname=:memory:', "", "");
$db->do('CREATE TABLE t1 (name VARCHAR)');

my $insert = $db->prepare('INSERT INTO t1 VALUES (?)');
$insert->execute("Maria's");

my $select = $db->prepare('SELECT * FROM t1');
$select->execute;
while (my @row = $select->fetchrow_array) {
    say "@row";  # Maria's
}