Is it possible to add custom SQL-based layers in GeoServer?

Question

I would like to add a layer to GeoServer that builds its features from an SQL query executed against a PostGIS database (something like a PostGIS layer in QGIS, but customized with additional SQL query).

Is it possible to have not a whole PostGIS geometries table, but some 'SELECT' from it to be published by GeoServer?

Answer 1

Yes, that should be possible in Geoserver 2.1 using SQLViews (Docs).

enter image description here