How does the code you showed fail for you?

Have you printed the generated SQL? Does the generated SQL work when run in the SQLite command line client?

Please see DBI especially about placeholders and bind values.

Have you tried searching for "Scarlett O'Hara" ?

Maybe DBIx::PreQL is interesting for you.