Our SQLite3 engine can now use regular
expression within its SQL queries, by enabling the REGEXP
operator in addition to standard SQL operators (= == != <> IS IN
LIKE GLOB MATCH
). It will use the Open Source PCRE library
(bounded since Delphi XE, or available as a separate download) to perform the
queries.
It will enable advanced searches within text columns and our objects, when used as a WHERE clause of our mORMot's ORM.