🚀 [Feature Request] Explicit SELECT statements

[insunaa]

Feature Details

Use explicit SELECT statements in source to replace SELECT * FROM queries.

Visualizations

No response

Benefits and Purpose

If DB tables are ever re-arranged we don't have to worry about suddenly getting nonsense from some hard-coded SQL queries

Core Versions

• 1.1.12 (Classic)
• 2.4.3 (The Burning Crusade)
• 3.3.5a (Wrath of the Lich King)

[insunaa]

Mainly opened this as a discussion/question. Should we allow SELECT * FROM queries in code or should we always explicitly SELECT explicitly named columns? We currently have 9 occurrences of SELECT * FROM in our code, a few more if we count the deprecated playerbots