All issues
Anti-pattern
Bug risk
Coverage
Documentation
Performance
Secrets
Security
Style
Type check
UNION
UNION [DISTINCT|ALL] is preferred over just UNION, because explicit is better than implicit.
UNION [DISTINCT|ALL]
SELECT a, b FROM table_1 UNION SELECT a, b FROM table_2
SELECT a, b FROM table_1 UNION DISTINCT SELECT a, b FROM table_2