Gary Varga (8/22/2013)
TBH I cannot remember the last time someone thought of writing SQL statements that were so SQL compliant that they were cross-RDBMS compatible. Most places I have worked develop a RDBMS specific data access layer but some do so whilst ensuring that it takes business entities or data transfer objects (i.e. database neutral types) so that the data access layer/tier can be replaced whilst the remaining parts of the application can remain. The same is true for the UI e.g. swapping ASP.NET MVC front end for a Java Server Pages implementation.
I took a PeopleSoft 7 (or maybe 8) training course on developing forms many moons ago.
PS had actually coded forms with both the Oracle and SQL Server SQL statements for all the DML statements. It read the config file and that told it which code to use.
You want to talk about bloatware...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.