public MetadataResultSet<RegistryObject> getRecords( MetadataQuery query )
                            throws MetadataStoreException {

        PreparedStatement stmt = null;
        ResultSet rs = null;
        ConnectionManager connManager = workspace.getSubsystemManager( ConnectionManager.class );
        Connection conn = getConnection( true );
        try {
            EOPropertyNameMapper propMapper = new EOPropertyNameMapper( query.getQueryTypeNames(), useLegacyPredicates );
            if ( query.getFilter() instanceof IdFilter ) {
                throw new MetadataStoreException( "ID filters are currently not supported." );
            }

            AbstractWhereBuilder wb = new PostGISWhereBuilder( null, propMapper, (OperatorFilter) query.getFilter(),
                                                               query.getSorting(), false, useLegacyPredicates );
            AliasedRIMType returnType = propMapper.getReturnType( query.getReturnTypeNames() );
            StringBuilder idSelect = new StringBuilder( "SELECT DISTINCT(" );