We've enabled REGEX to be used with the spatialite provider. (This comes in handy when setting filters!). We've also added support for this syntax via any python connections made through Qgis.utils's "spatialite_connection" API - allowing you to use REGEXP in your SQL queries from within DB Manager.
This feature was developed by Mathieu Pellerin