As far as "native" support of databases is concerned there are still only Derby, MySQL, SQL Server/MSDE/SQL Express (native support for Oracle is coming soon in an Enterprise Edition).
With non-native support you can work with any database that has a JDBC driver (nowadays it is pretty much any SQL database).
Here are the limitations of a "non-native" support:
1) Attribute types are always "discovered" - if a database table uses some exotic column type that Aware IM cannot work with, it will be ignored
2) You cannot have references to other objects inside an object created from an existing database table (but you can have references to such objects inside other "normal" Aware IM objects)
3) You cannot have Picture or Document attributes in such objects (but you can have BINARY attributes)
4) You have to indicate primary key(s) for objects created from existing database tables. If you don't, you will only be able to query such objects, but you won't be able to view and/or modify individual records.
For many situations these limitations will not be a problem.