What is ad hoc query?
A query is a question you ask a database in the form of a SQL statement. When software developers develop software, they typically define certain queries with the delivered software as reports, forms, or accessible via query windows. Ad hoc queries are those that are not already defined that are not needed on a regular basis, so they’re not included in the typical set of reports or queries provided with the software. They’re typically queries that the user can create on their own outside the scope of the delivered software.