-
Introduced
QueryBuilder.CombineUnion(sql string, unionClause string) stringto allow specifying how theUNION/UNION ALLstatements should be concatenated to the base query.
To minimize breaking changes the defaultBaseQueryBuilderimplementation is preserved as before - aka. wraps the left and right side of the combined queries in parenthesis (this is not a standard SQL format and it is mostly a MySQL quirk). -
Use custom
SqliteQueryBuilderfor theSqliteBuilderthat removes the default parenthesis wrapping ofUnion()/UnionAll()statements because otherwise it is causing syntax error (see pocketbase#7516).