Filtering: string lookups by regular expression

[dc6c]

Django has the FIELD__regex queryset, and I don't think Oxyde has it yet. Is there an alternative way to get this kind of functionality, or are there any plans to add this lookup to string fields?

[mr-fatalyst]

Thanks for the suggestion! Currently regex/iregex lookups are not implemented.

For most use cases, the existing string lookups should cover you:

• name__contains="pattern" — LIKE '%pattern%'
• name__startswith="prefix" — LIKE 'prefix%'
• name__endswith="suffix" — LIKE '%suffix'
• Case-insensitive variants: icontains, istartswith, iendswith

For cases where you truly need regex, you can use raw SQL:

# PostgreSQL 
await execute_raw("SELECT * FROM users WHERE name ~ $1", [r"^A.*z$"])                                     
# MySQL 
await execute_raw("SELECT * FROM users WHERE name REGEXP ?", [r"^A.*z$"])

Adding __regex as a built-in lookup is complicated by dialect differences (PostgreSQL uses /*, MySQL uses REGEXP, SQLite has no built-in support). I may revisit this in the future, but for now it's not on the roadmap.

[dc6c]

Thank you for the quick reply, I'm OK with that. Should I close the issue or do you prefer to keep "future ideas" open?

[mr-fatalyst]

Glad that covers your use case! Let's keep this open as a future tracking issue, and it might help others with the same question.