> And I would rather have a simple SQL statement that would return
> these things than an API call.

Me not :) Two reasons:

- the result set will contain rows with either numeric or text constants
with some meaning. While this might be more user readable, the values of
the constants won't be defined in some public API (ibase.h) and won't
have so-to-say "official" status... But that is my personal thing...

- statement call requires at least 3 roundtrips to the server. You might
not see this while using isc_dsql_exec_immediate, but the roundtrips are
there.

But that is my personal opinion. And, I suspect, implementing the API
call is easier than supporting such statement.

Roman