+ static wherePreferredUsername (preferredUsername: string, colName = 'preferredUsername') {
+ return where(fn('lower', col(colName)), preferredUsername.toLowerCase())
+ }
+
+ // ---------------------------------------------------------------------------
+