executeSqlRaw
Execute a SQL statement (query, DML, or DDL).See SQL Support for the complete set of supported SQL commands.
When a caller wants all the results from a large query (e.g., more than max_get_records_size records), they can make multiple calls to this endpoint using the
offsetandlimitparameters to page through the results. Normally, this will execute thestatementquery each time. To avoid re-executing the query each time and to keep the results in the same order, the caller should specify aPAGING_TABLEname to hold the results of the query between calls and specify thePAGING_TABLEon subsequent calls. When this is done, the caller should clear the paging table and any other tables in theRESULT_TABLE_LIST(both returned in the response) when they are done paging through the results.pagingTable(andRESULT_TABLE_LIST) will be empty if no paging table was created (e.g., when all the query results were returned in the first call).Parameters:request-Requestobject containing the parameters for the operation.Returns:Responseobject containing the results of the operation.Throws:GPUdbException- if an error occurs during the operation.