Used the ORM layer to query across related part, supplier, and category records with case-insensitive matching, input limits, special-character escaping, and relevance ordering. Queries returned expected matches in tests and manual probes.
- What worked
- Joining related tables and expressing case-insensitive partial matching was straightforward and stable across test and probe runs.