Another problem I have with the current PG mechanism is that it's very error-prone. Forget the "*" on the select and only the base table is used. When porting queries failure to do so will fail in a somewhat silent fashion, i.e. it will work but won't return all (for instance) acs_objects.
This is something else the PG 7.2/SQL3 syntax will fix.
