SqlResult

Create a new SqlResult from an RawExecuteSqlResponse

Create a SqlResult with column name mapping

The column_names slice should contain the column names in order, which will be mapped to column_1, column_2, etc.

Get the underlying RawExecuteSqlResponse

Consume and return the underlying RawExecuteSqlResponse

Get the total number of records matching the query (before LIMIT)

Get the number of records affected by the query (INSERT/UPDATE/DELETE)

Check if there are more records available (for paginated queries)

Get the paging table name (if any)

Get info metadata from the response

Get the raw JSON response string

Get the number of rows in the result

Get all column names in the result

Returns the raw column names (column_1, column_2, etc.) unless column mapping was provided via with_column_names.

Extract a single column as a Vec

use gpudb_api::SqlResult;

let ids: Vec<i64> = result.column("column_1")?;
let names: Vec<String> = result.column("column_2")?;

Get a single scalar value from the first row, first column

Useful for queries like SELECT COUNT(*) FROM table

use gpudb_api::SqlResult;

let count: i64 = result.scalar()?;

Get a value from a specific row and column

Iterate over rows in the result

use gpudb_api::SqlResult;

for row in result.rows()? {
    let id: i64 = row.get("column_1")?;
    let name: String = row.get("column_2")?;
    println!("id={}, name={}", id, name);
}

Deserialize all rows into a Vec of structs

use gpudb_api::SqlResult;
use serde::Deserialize;

#[derive(Deserialize)]
struct User {
    column_1: i64,  // id
    column_2: String,  // name
}

let users: Vec<User> = result.deserialize()?;
for user in users {
    println!("id={}, name={}", user.column_1, user.column_2);
}