Subject: | Sub query not compatible with posgresql |
The "subquery" method does not work with PostgreSQL as a table alias is
required:
DBD::Pg::st execute failed: ERROR: subquery in FROM must have an alias
HINT: For example, FROM (SELECT ...) [AS] foo