{"record":{"id":"b0ea2d2ec5c08d66","repo":"diegosouzapw/OmniRoute","slug":"getproviderconnections-invalid-column-s-requeste","errorCode":null,"errorMessage":"getProviderConnections: invalid column(s) requested: ${invalidColumns.join(\", \")}","messagePattern":"getProviderConnections: invalid column\\(s\\) requested: (.+?)","errorType":"exception","errorClass":null,"httpStatus":null,"severity":"error","filePath":"src/lib/db/providers.ts","lineNumber":255,"sourceCode":" * Used by the lazy-decryption path in auth selection (auth.ts) where\n * 10k+ connections are filtered in JS but only 1 needs its apiKey\n * decrypted.\n *\n * @param limit — Optional SQL LIMIT clause to cap rows returned\n * @param offset — Optional SQL OFFSET for pagination\n */\nexport async function getRawProviderConnections(\n  filter: JsonRecord = {},\n  limit?: number,\n  offset?: number,\n  columns?: string[]\n) {\n  const db = getDbInstance() as unknown as DbLike;\n  let selectCols = \"*\";\n  if (columns?.length) {\n    const invalidColumns = columns.filter((col) => !PROVIDER_CONNECTIONS_COLUMNS.has(col));\n    if (invalidColumns.length > 0) {\n      throw new Error(\n        `getProviderConnections: invalid column(s) requested: ${invalidColumns.join(\", \")}`\n      );\n    }\n    // \"group\" is a reserved SQL keyword — the schema declares it quoted, so\n    // it must be re-quoted here too or the generated SELECT is a syntax error.\n    selectCols = columns.map((col) => (col === \"group\" ? `\"group\"` : col)).join(\", \");\n  }\n  let sql = `SELECT ${selectCols} FROM provider_connections`;\n  const conditions: string[] = [];\n  const params: Record<string, unknown> = {};\n\n  if (filter.provider) {\n    conditions.push(\"provider = @provider\");\n    params.provider = filter.provider;\n  }\n  if (filter.isActive !== undefined) {\n    conditions.push(\"is_active = @isActive\");\n    params.isActive = filter.isActive ? 1 : 0;","sourceCodeStart":237,"sourceCodeEnd":273,"githubUrl":"https://github.com/diegosouzapw/OmniRoute/blob/a179ffed5bb2e0b883b9ae7214ce8717b2a94c4d/src/lib/db/providers.ts#L237-L273","documentation":"Error \"getProviderConnections: invalid column(s) requested: ${invalidColumns.join(\", \")}\" thrown in diegosouzapw/OmniRoute.","triggerScenarios":"Thrown at src/lib/db/providers.ts:255 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":[],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"a179ffed5bb2e0b883b9ae7214ce8717b2a94c4d","analyzedAt":"2026-08-25T18:35:09.898Z","schemaVersion":2},"datasetVersion":"2026-08-25T21:54:21.419Z"}