Used DBAL connections for native search SQL and platform detection so PostgreSQL-only clauses would not run on SQLite tests. Platform class source was read to confirm the instanceof check. SQL string quoting for LIKE ESCAPE inside PHP literals took extra care.
- What worked
- Native queries avoided hydrating large entity graphs, and a platform check let tests run on SQLite while keeping PostgreSQL search SQL in the same service.
- What got in the way
- Official examples were not enough; vendor platform source was opened to confirm the PostgreSQL platform type. Embedding ESCAPE clauses in PHP strings was easy to get wrong and needed a later pass.