Hi,
The company I work for has one software application that uses an IRIS database, with almost all the others using SQL databases.
On a SQL database, we can create local tables and create views. These are invaluable when it comes to reporting, and everyone here is quite up to speed with using SSMS to create functions, stored procedures, etc.