如何在布尔查询中只选择一个分支

-- 假设用户输入的条件是 age > 25 或 city = 'New York'
-- 我们希望只执行其中一个分支

SELECT * FROM users
WHERE (age > 25 OR city = 'New York')
AND (age > 25 XOR city = 'New York');

# 假设我们有一个用户列表
users = [
    {'id': 1, 'name': 'Alice', 'age': 30, 'city': 'New York'},
    {'id': 2, 'name': 'Bob', 'age': 25, 'city': 'Los Angeles'},
    {'id': 3, 'name': 'Charlie', 'age': 35, 'city': 'Chicago'}
]

# 用户输入的条件是 age > 25 或 city = 'New York'
# 我们希望只执行其中一个分支
age_condition = lambda user: user['age'] > 25
city_condition = lambda user: user['city'] == 'New York'

filtered_users = [
    user for user in users
    if (age_condition(user) or city_condition(user))
    and (age_condition(user) != city_condition(user))
]

print(filtered_users)