如何使用分组的OR建立WHERE查询

Goal: using the golang lib GORM.io, trying to generate a WHERE clause (programmatically) with (potentially multiple) 'OR' clauses grouped together.

Example:

Bad

SELECT * FROM ... WHERE (x = 'one') OR (y = 'two') OR (z = 'three')

Good

SELECT * FROM ... WHERE (x = 'one' AND (y = 'two' OR z = 'three'))

I've...

• read the GORM documentation end to end
• looked at the GORM source code; and tried doing this with Scopes(), SubQuery(), and Expr() to extract only the (what GORM internally refers to as the 'search' field) and generating the SQL string automatically
• scoured the depths of stack overflow for an answer to this
• considered giving up and going to be a shepherd in new zealand

Latest attempt and how I think something like this would be solved...ish.

q := gorm.DB
q.Where(`x=?`, `one`).Where(
  gorm.<NewScopeMaybe?).Or(`y=?`, `two`).Or(`z=?`,`three`).Expr()
)

If anyone has some insight, I won't buy you a beer but I will upvote the hell out of your answer and tell my mom to register for stack overflow so she too can upvote your answer.