PostgreSQL compatibility: Quote column names in WHERE clauses

[wazum]

Problem

xhgui fails with PostgreSQL databases when filtering or viewing traces, showing:

  SQLSTATE[42703]: Undefined column: column "server" does not exist

PostgreSQL treats unquoted identifiers as lowercase, but xhgui's schema uses mixed-case column names (SERVER, simple_url, request_ts, etc.).

Solution

Quote all column names in WHERE clauses to preserve their exact case, making the queries work correctly with PostgreSQL while maintaining MySQL compatibility.

This is compatible and non-breaking for MySQL/MariaDB, as xhgui is already setting ANSI_QUOTES in src/ServiceProvider/PdoStorageProvider.php:

'SET SQL_MODE=ANSI_QUOTES;'

[gourvy]

xhgui seems to use 3 columns with upper-case: SERVER GET ENV.
A workaround:

sed -i 's/ and SERVER like / and "SERVER" like /g' /var/www/xhgui/src/Db/PdoRepository.php