Programming Language vs. Database Syntax

By Deane Barker on March 30, 2004

Joel on Software: A really interesting point here.

…language designers never bother to put database integration features into their languages. As a tiny example of this, the syntax for “where” clauses is never identical to the syntax for “if” statements. And don’t get me started about data type mismatches: just the fact that columns of any type might be “null” leads to an incompatibility between almost every native data type and the database data types.

This reminds me of that HTML/OS system from Aestiva which had the RDBMS built-in to the programming language.