volos-connectors-common: set SQL limit to 1 when querying single resource

When requesting a single resource from a collection by ID, e.g. /collection/{id}, request at most a single row from the DB