"group by" is generated with an incorrect position

[rorsarach]

WP Version: 6.8.3
PG4WP Version: V3

Error:

ERROR:  syntax error at or near "GROUP"
LINE 2:                                 WHERE GROUP BY post_status

RAW SQL

SELECT post_status, COUNT( * ) AS num_posts FROM wp_posts WHERE post_type = 'page' GROUP BY post_status

Expected Rewritten SQL

SELECT post_status, COUNT(*) AS num_posts FROM wp_posts WHERE post_type = 'page' GROUP BY post_status

Actual Rewritten SQL

SELECT post_status, COUNT(*) AS num_posts FROM wp_posts WHERE GROUP BY post_status

[wilsonify]

looks like The WHERE clause is dropped by SelectSQLRewriter::ensureGroupByOrAggregate() (SelectSQLRewriter.php:280-349), causing all rows returned instead of filtered subset.

The regex at line 288 fails when the WHERE clause contains subqueries (nested parentheses), causing $whereClause to be empty. The clause is then omitted from the rebuilt query.

my proposal is to inject GROUP BY directly before ORDER BY . Instead of parsing and reassembling, thoughts?