Script Development / ClickHouse

ClickHouse connector operation objects mainly provide some data methods.

DFF.CONN(...) parameters are as follows:

Parameter	Type	Required / Default Value	Description
`connector_id`	str	Required	Connector ID
`database`	str	`None`	Specified database

`.query(...)`

Executes an SQL statement, with the following parameters:

Parameter	Type	Required / Default Value	Description
`sql`	str	Required	SQL statement, can include parameter placeholders. `?` represents an escaped parameter; `??` represents a non-escaped parameter
`sql_params`	list	`None`	SQL parameters

Example
sql = 'SELECT * FROM ?? WHERE age > ?'
sql_params = ['demo_table', 50]
result = helper.query(sql, sql_params=sql_params)

query(...) and non_query(...) use DFF.SQL(...) internally to construct SQL statements and support building complex dynamic SQL statements.

For example, when using WHERE IN (...) with an uncertain number of values, or performing bulk data insertion with INSERT INTO ... VALUES ....