I am hoping to begin writing a technical article soon that will introduce database application developers to these idiosyncrasies who are new to Firebird, making their initial forays into using this database engine less frustrating.

I have always believed that these types of issues have kept Firebird from being realized as a top-contender in the database world.  It is based upon an excellent technology foundation and should be exposed more generally for the excellent and highly efficient engine that it really is...