Search across all columns in a table
Full Text Search

You can use FTS5

CREATE VIRTUAL TABLE customer USING tblCustomers(col1, col2, col3);


Then you just

SELECT * FROM tblCustomers WHERE email MATCH 'keyword AND keyword2';