如何从具有多个AND-条件的数组生成WHERE子句

def generate_where_clause(conditions):
    where_clause = ""
    for condition in conditions:
        field = condition['field']
        operator = condition['operator']
        value = condition['value']
        where_clause += f"{field} {operator} {value} AND "
    where_clause = where_clause[:-5]  # 移除最后的 " AND "
    return where_clause

# 示例条件数组
conditions = [
    {'field': 'age', 'operator': '>', 'value': 18},
    {'field': 'gender', 'operator': '=', 'value': 'female'},
    {'field': 'country', 'operator': 'IN', 'value': ('USA', 'Canada', 'UK')}
]

where_clause = generate_where_clause(conditions)
print(f"WHERE {where_clause}")

WHERE age > 18 AND gender = 'female' AND country IN ('USA', 'Canada', 'UK')