chdb_sql_query_csv_file_and_inmemory_data.py

1import chdb
2
3# Query a CSV file directly using SQL
4res = chdb.query("SELECT * FROM 'data.csv' WHERE id > 10", "CSV")
5print(res)
6
7# Query data in memory (Python list of dictionaries)
8data = [
9    {"name": "Alice", "age": 30},
10    {"name": "Bob", "age": 25}
11]
12res = chdb.query("SELECT name, age FROM Python(data) WHERE age > 26", "JSON")
13print(res)