I'm facing an issue with sqlite3.OperationalError: unknown function: CONCAT_WS() in my Python 3.12 application. I'm using the sqlite3 module to connect to an SQLite database via an ODBC driver (/) in Windows 10. My SQLite3 version is 3.46.0.

The traceback is:

Exception in Tkinter callback
Traceback (most recent call last):
  File "D:\Programs\Python\Python312\Lib\tkinter\__init__.py", line 1948, in __call__
    return self.func(*args)
  File "C:\Users\HP\.virtualenvs\xxxxx\Lib\site-packages\customtkinter\windows\widgets\ctk_button.py", line 554, in _clicked
    self._command()
  File "C:\Users\HP\Desktop\Projects\xxxxx\xxxxx\src\checker.py", line 447, in on_button_search_click
    record = view_formatted_record("queries/door/view_formatted_record.sql", **entries)
  File "C:\Users\HP\Desktop\Projects\xxxxx\xxxxx\src\widget_functions\actions.py", line 65, in view_formatted_record
    result, description = execute_query(query_path, fetchone=True, **query_params)
  File "C:\Users\HP\Desktop\Projects\xxxxx\xxxxx\src\widget_functions\actions.py", line 38, in execute_query
    raise e
  File "C:\Users\HP\Desktop\Projects\xxxxx\xxxxx\src\widget_functions\actions.py", line 25, in execute_query
    cursor.execute(sql_query.read(), query_params)
sqlite3.OperationalError: unknown function: CONCAT_WS()

The error occurs when I try to query a virtual column that uses the CONCAT_WS function. Table definition is:

CREATE TABLE IF NOT EXISTS person (
    id_person INTEGER PRIMARY KEY,
    first_name TEXT NOT NULL CHECK(LENGTH(first_name) <= 50 AND first_name GLOB '[A-ZÑ]*'),
    middle_name TEXT CHECK(LENGTH(middle_name) <= 50 AND middle_name GLOB '[A-ZÑ]*'),
    last_name TEXT NOT NULL CHECK(LENGTH(last_name) <= 50 AND last_name GLOB '[A-ZÑ]*'),
    full_name TEXT GENERATED ALWAYS AS (CONCAT_WS(' ', first_name, middle_name, last_name)) VIRTUAL,
    id_sex INTEGER NOT NULL,
    birth_date TEXT
)
STRICT;

The query in question is this one:

SELECT
  id_person
, full_name
, id_sex
FROM person

Interestingly, the same query works perfectly fine in both Beekeeper Studio, DBeaver and WSL2, but not in Windows or any PowerBI/Excel source using the ODBC driver.