I am working with a number of detailed ArcGIS Geodatabases with domains used to enforce specific workflows, etc. This is all good and great, but I would like to move my data into either a PostgreSQL/PostGIS or SQL Azure datastore and would like the ESRI client APIs (Mobile SDK, Web APIs, and Desktop templates) to enforce workflows in a similar manner to Geodatabase domains. Obviously a domain is nothing more than a table constraint, but there is lots of built in ArcGIS functionality which makes life easier for the end user (mainly desktop users). This seems very timely since it appears that at 10.1 ESRI is expanding support for native spatial support (i.e. Simple Features).
Will ESRI provide domain support within a native spatial DB from ArcGIS Desktop? Thoughts, suggestions, etc.