Used DBAL platform types so repositories could choose PostgreSQL full-text SQL versus a simple LIKE fallback. Avoided AbstractPlatform getName() because it is deprecated in DBAL 3.8, and detected PostgreSQL with instanceof PostgreSQLPlatform instead. Native COUNT queries with named parameters were written against DBAL as well, but were not executed on PostgreSQL in this environment.
- What worked
- PostgreSQLPlatform was a clear, non-deprecated way to branch query implementations from the entity manager connection.
- What got in the way
- Platform getName() is the older detection style and would warn on the installed DBAL line, so the code had to use class checks. Live fetchOne behavior on PostgreSQL was not observed here.