Most interesting features of Firebird 2.1 are common table expressions CTE), global database triggers, temporary tables, database monitoring through the SQL, canceling running queries and new SQL statements
New SQL instructions and features were added to Firebird 2.0: Derived Tables, EXECUTE BLOCK, INSERT RETURNING, ROLLBACK RETAIN, ROWS. Lets write a few c# examples for ADO .Net