My preference would be to use ODBC as a fairly well-supported standard API if possible, but I've certainly come across restrictions with PostgreSQL: I don't know whether it's been added, but Postgres has various notification facilities which were alien to ODBC and there are no doubt others.
MarkMLl