SQL query in Geoserver

Question

Does anyone know why geoserver does not implement a direct SQL query when setting up a layer?

Answer 1

The developers just have not reached it yet. (There is no need for this function, since GeoServer can work with a database view as easily as with a table.) However, now GeoServer can dynamically change the SQL used to extract functional data from databases. This functionality is discussed in the GeoServer user guide at http://docs.geoserver.org/stable/en/user/data/database/sqlview.html