Function: executeSync()

executeSync(args: { lix: Pick<Lix, "sqlite">; query: any; }): any[]

Execute a query synchronously.

⚠️ MAJOR WARNING: This function is a PURE SQL LAYER without transformations!

  • JSON columns return as RAW JSON STRINGS, not parsed objects
  • You must manually parse/stringify JSON data
  • No automatic type conversions happen
  • Results are raw SQLite values

Only use this for triggers, database functions, or when you specifically need synchronous database access and understand you're working with raw SQL.

Example

// JSON columns are returned as strings - you must parse manually:
  const result = executeSync({ lix, query });
  result[0].metadata = JSON.parse(result[0].metadata);

Parameters

ParameterType
args{ lix: Pick<Lix, "sqlite">; query: any; }
args.lixPick<Lix, "sqlite">
args.queryany

Returns

any[]