How to create custom function in a QSqlDatabase: regex in sqlite and pyqt

We define the python type REGEXP function in sqlite and python following Problem with regexp python and sqlite

How can we do the same thing in PyQT, ie. with a QSqlDatabase?

More precisely, we use the REGEXP function to create a view:

Create view temp as select * from somewhere where columnname REGEXP 'myregex';

This works well, as long as we do the select from python. We would like to show the result in a QTableView (via a QSqlTableModel filled with the view). As the view uses the REGEXP, we would have to link the python regex function to the QSqlDatabase.

Is there a way of doing that?

Thanks in advance!