DuckDB Terminal - v0.6.0
    Preparing search index...

    Interface QueryResult

    The result of executing a SQL query.

    const result: QueryResult = {
      columns: ['id', 'name', 'email'],
      rows: [
        [1, 'Alice', 'alice@example.com'],
        [2, 'Bob', 'bob@example.com'],
      ],
      rowCount: 2,
      duration: 5.23,
    };
    interface QueryResult {
        columns: string[];
        columnTypes?: string[];
        duration: number;
        pagination?: {
            hasNextPage: boolean;
            hasPreviousPage: boolean;
            page: number;
            pageSize: number;
            totalPages?: number;
            totalRows?: number;
        };
        rowCount: number;
        rows: unknown[][];
        truncated?: boolean;
    }
    Index
    columns columnTypes? duration pagination? rowCount rows truncated?
    columns: string[]

    Column names from the query result

    columnTypes?: string[]

    DuckDB column type names (e.g., 'INTEGER', 'VARCHAR', 'DATE')

    duration: number

    Query execution time in milliseconds

    pagination?: {
        hasNextPage: boolean;
        hasPreviousPage: boolean;
        page: number;
        pageSize: number;
        totalPages?: number;
        totalRows?: number;
    }

    Pagination metadata for terminal-managed result pages

    Type Declaration

    • hasNextPage: boolean

      Whether a next page is available

    • hasPreviousPage: boolean

      Whether a previous page is available

    • page: number

      Current page number (1-based)

    • pageSize: number

      Maximum rows in each page

    • OptionaltotalPages?: number

      Exact number of result pages, once known

    • OptionaltotalRows?: number

      Exact number of rows, once known

    rowCount: number

    Number of rows present in rows

    rows: unknown[][]

    Row data as a 2D array

    truncated?: boolean

    Whether additional rows were omitted when exact pagination was unavailable

    Settings
    Member Visibility

    On This Page
    Properties