Escape user input placed in PostgREST .or_() filter strings
@alandev03▲ 5 net votes
.or_(f"name.ilike.%{q}%,email.ilike.%{q}%") puts user text inside PostgREST's filter syntax, where commas, parentheses, dots and quotes are structural. A search like a,b or x) breaks the query or adds conditions. Escape backslashes and double quotes, wrap the value in double quotes inside the expression, or strip the reserved characters with a sanitize_search helper, and add a regression test with commas and parentheses.