The ExecuteSQL function introduced in version 12 is a powerful tool for querying your database in a contextless fashion. One of its limiting features is it's lack of debugging help when it comes to writing properly formed queries, with the function returning a "?" if you get something wrong. Turns out there is more to that question mark than meets the eye and within the question mark contains some useful descriptive error messages.
Read more →