#27 Named Queries

[Anonymous]

I will often have a series of queries that are quite
long, with small subtle differences so I can review my
data different ways.

In the Custom Query form, it would be nice if we could
give our "Favorite Queries" names, kind of like
bookmarks. If the name is blank, show the query,
otherwise show the name.

So for example, if I had these two SIMPLE examples:

SELECT * FROM user WHERE userID > 10
SELECT * FROM user WHERE userID > 10 ORDER BY lastName

and presuming that users 0-9 where special admin
records, e.g.
I could name them for my own "bookmarks"

List non-admin users
List alpha non-admin users

Then -- at 2AM, when I'm trying to figure out where the
query is -- I could read English (or my language of
choice) instead of SQL :)

[Nobody/Anonymous]

Logged In: NO

If you add a comment to the query on its own line, exempli gratia:

# Sorted by last name
SELECT
userID,lastName
FROM
user
WHERE
userID > 10
ORDER BY
lastName

This shows up on the dropdown as just the comment. It is a little tricky (to say
the least) to maintain, but works for me!