There's a DBI interface to it. It has triggers, stored procedures, and all that jazz. Has anyone here used it?
What really grabbed me about the Firebird project is the website. VERY nicely designed. Extremely fast loading without being too vanilla. It's definitely worth a poke around. The only bit I found that was lacking in content was the FAQ section (in particular the last question