SQLite3 has the REGEXP keyword. That means we can do SQLite queries like
SELECT * FROM table1 WHERE col1 REGEXP '\d+[a-z]+\d*';
.
Unfortunately, the REGEXP keyword references an SQLite user defined function that is not defined by default. That means if we want to use REGEXP in our SQLite...