Atif

Updated India.json with new province

1

Added new province Ladakh to the list of the province.

Proposal: Add countries capital name

1

Can we add countries capital name maybe as a separate function to get the capital name. I dont think so there is any ISO code file containing capital name but...

Power BI ODBC: ClickHouse throws 'CANNOT_INSERT_NULL_IN_ORDINARY_COLUMN' on Nullable Int/Decimal fields in DirectQuery mode

10

### Problem ClickHouse fails with the following error when queried via Power BI (ODBC) in DirectQuery mode: ``` DB::Exception: Cannot convert NULL value to non-Nullable type... (CANNOT_INSERT_NULL_IN_ORDINARY_COLUMN) ``` This occurs...

Power BI DirectQuery: ClickHouse fails to parse ODBC parameter placeholders in expressions (e.g., CAST/LEFT)

3

### Problem When connecting ClickHouse to Power BI using DirectQuery via the ClickHouse ODBC driver, Power BI generates queries like: ```sql left(cast(`persona_id` as String), {odbc_positional_1:Nullable(Int32)}) ``` This syntax is valid...