SAGA.db_odbc.8: Import Table from SQL Query

{"id": "SAGA.db_odbc.8", "title": "Import Table from SQL Query", "description": "Import a SQL table from a database via ODBC.", "version": "1.0.0", "jobControlOptions": ["sync-execute", "async-execute", "dismiss"], "outputTransmission": ["value", "reference"], "links": [{"rel": "http://www.opengis.net/def/rel/ogc/1.0/execute", "type": "application/json", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.db_odbc.8/execution"}, {"rel": "alternate", "type": "text/html", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.db_odbc.8/execution.html"}], "inputs": {"ODBC_DSN": {"title": "DSN", "description": "Data Source Name", "schema": {"type": "string", "nullable": true}, "id": "ODBC_DSN"}, "ODBC_USR": {"title": "User", "description": "User Name", "schema": {"type": "string", "nullable": true}, "id": "ODBC_USR"}, "ODBC_PWD": {"title": "Password", "description": "Password", "schema": {"type": "string", "nullable": true}, "id": "ODBC_PWD"}, "CONNECTION": {"title": "Server Connection", "description": "Server Connection", "schema": {"type": "string", "nullable": true}, "id": "CONNECTION"}, "TABLES": {"title": "Tables", "description": "Tables", "schema": {"type": "string", "nullable": true}, "id": "TABLES"}, "FIELDS": {"title": "Fields", "description": "Fields", "schema": {"type": "string", "default": "*", "nullable": true}, "id": "FIELDS"}, "WHERE": {"title": "Where", "description": "Where", "schema": {"type": "string", "nullable": true}, "id": "WHERE"}, "GROUP": {"title": "Group by", "description": "Group by", "schema": {"type": "string", "nullable": true}, "id": "GROUP"}, "HAVING": {"title": "Having", "description": "Having", "schema": {"type": "string", "nullable": true}, "id": "HAVING"}, "ORDER": {"title": "Order by", "description": "Order by", "schema": {"type": "string", "nullable": true}, "id": "ORDER"}, "DISTINCT": {"title": "Distinct", "description": "Distinct", "schema": {"type": "boolean", "default": false, "enum": ["true", "false"], "nullable": true}, "id": "DISTINCT"}}, "outputs": {"TABLE": {"title": "Table from SQL Query", "description": "Table from SQL Query", "extended-schema": {"oneOf": [{"allOf": [{"$ref": "http://zoo-project.org/dl/link.json"}, {"type": "object", "properties": {"type": {"enum": ["text/csv", "text/csv"]}}}]}, {"type": "object", "required": ["value"], "properties": {"value": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}}}]}, "schema": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}, "id": "TABLE"}}}