Function parseSQLQuery

packages/expo-sqlite/src/queryUtils.ts:31–55

(query: string)

 * ```
 */
export function parseSQLQuery(query: string): SQLParsedInfo {
  // Remove quoted strings to avoid false positives
  // SQLite uses doubled quotes for escaping: 'don''t' or "test""quote"
  const cleaned = query
    .replace(SINGLE_QUOTED_STRING, "''") // Remove single-quoted strings
    .replace(DOUBLE_QUOTED_STRING, '""'); // Remove double-quoted strings

  // Priority 1: Check for RETURNING (highest priority - makes any query return rows)
  if (RETURNING_KEYWORD.test(cleaned)) {
    return { canReturnRows: true };
  }

  // Priority 2: Check for mutations (these don't return rows unless they have RETURNING)
  if (MUTATION_KEYWORDS.test(cleaned)) {
    return { canReturnRows: false };
  }

  // Priority 3: Check for queries (these return rows)
  if (QUERY_KEYWORDS.test(cleaned)) {
    return { canReturnRows: true };
  }

  // Default: doesn't return rows
  return { canReturnRows: false };
}