DuckDB ^ operator is parsed incorrectly as XOR when it should be POW

[rustyconover]

When testing SQLGlot with DuckDB, there is a parsing error when using the ^ operator in SQL statements. SQLGlot incorrectly translates this to the XOR function, whereas in DuckDB, the ^ operator is used for exponentiation (power).

Original Query:

SELECT ?::DOUBLE ^ ?::DOUBLE LIMIT 1

SQLGlot Translation:

SELECT XOR(CAST(? AS DOUBLE), CAST(? AS DOUBLE)) LIMIT 1

Expected Behavior:

The translation should retain the ^ operator, as it computes the power of x to y in DuckDB:

SELECT ?::DOUBLE ^ ?::DOUBLE LIMIT 1

DuckDB Reference:

By inspecting the DuckDB function definitions, the ^ operator is defined as the exponentiation function:

SELECT * FROM duckdb_functions() WHERE function_name = '^';