SQLite Forum

How to select columns that have name beginning with same prefix?
Login
How is that unreadable (and likely unworkable) glop of text better than:<code>
  SELECT
    "USER.NickName" as Nickname, "USER.Password" as Password
  FROM "USERS"
</code>?

In other words, why go to the trouble of writing a longer and less readily comprehended query that requires an eval() step to work?