Query is a more general term that refers to the act of selecting data
and could be saved (a view) or a select statement sent from a client
app. An ad hoc query usually refers to a query that is constructed in
client code by stitching together input from the user. The
concatenated SELECT statement (query) is then sent to the server to be
executed.

--Mary

[quoted text, click to view]