SQL Interface

const result = await client.sql(
  'SELECT * FROM my_app::users WHERE email = "alice@example.com"',
  { includeHistory: false }
);

console.log(result.data);       // Array of matching records
console.log(result.count);      // Total count
console.log(result.query);      // Executed query string
console.log(result.app_id);     // App ID
console.log(result.collection); // Collection name

const result = await client.sql(
  'SELECT * FROM my_app::users WHERE active = true',
  { includeHistory: true }
);

await client.sqlInsert(
  'INSERT INTO my_app::users (email, name, active) VALUES ("alice@example.com", "Alice", true)'
);

-- Select with filtering and sorting
SELECT * FROM my_app::products WHERE price > 10 ORDER BY price ASC LIMIT 20

-- Select specific fields
SELECT name, email, created_at FROM my_app::users WHERE active = true

-- Pagination
SELECT * FROM my_app::logs ORDER BY timestamp DESC LIMIT 50 OFFSET 100

-- Insert a record
INSERT INTO my_app::users (email, name, active) VALUES ("bob@example.com", "Bob", true)

interface SqlQueryResponse {
  data: any[];       // Array of matching records
  count: number;     // Number of records returned
  query: string;     // The SQL query that was executed
  app_id: string;    // Application ID
  collection: string; // Collection name
}