Function executeRawSQL

apps/desktop/main/worker/query/sql.ts:58–77

(sessionId: string, sql: string)

 * Returns columnar format with timing for the legacy IPC contract.
 */
export function executeRawSQL(sessionId: string, sql: string): SQLResult {
  const adapter = ensureAdapter(sessionId)

  try {
    const result = executeSql(adapter, sql, { columnar: true, timing: true, maxRows: 0 })
    return {
      columns: result.columns,
      rows: result.rows as unknown[][],
      rowCount: result.rowCount,
      duration: result.duration ?? 0,
      limited: result.truncated,
    }
  } catch (error) {
    if (error instanceof Error) {
      const message = error.message.replace(/^SQLITE_ERROR: /, '').replace(/^SQLITE_READONLY: /, '')
      throw new Error(message)
    }
    throw error
  }
}