Subject Max length of SQL statement
Author Stephen Boyd
Is there a maximum length for an SQL statement inherent in Firebird?
I am working on something right now where I generate a SELECT
statement of the form:

SELECT * FROM SOME_TABLE WHERE THE_KEY IN (...)

where the IN clause can conceivably contain a rather long list of
primary keys to be retrieved.

I am wondering if I am eventually going to run into some limit that
will bite me on the butt using this approach.