2010-Dec-21, Tuesday

English borked SQL

2010-Dec-21, Tuesday 01:01 pm
mellowtigger: (penguin coder)

I have suggested before that our language influences our thoughts, and that influence determines how we conceive the world, and that conception changes how we act in the world.

I noticed today a totally new way in which the influence of English language affected (negatively) the creation of a computer language. I already knew some Structured Query Language (SQL), but I'm taking a 3-day class this week in Microsoft SQL Server 2008's version of Transact-SQL. I noticed today that SQL syntax was badly influenced by one of the regrettable features of English syntax:

Adjectives precede Nouns.


I noticed the problem because of the Intellisense feature of the SQL Server management interface. As I type a new SQL command, the program determines context and shows me available choices that are appropriate within that point of the SQL command. The problem, unfortunately, is that SQL syntax puts the field names (adjectives) BEFORE the table names (nouns), so context can't yet be determined.

If we had more reasonable English syntax where nouns preceded adjectives (as in Spanish language), the SQL standard would have been created with the appropriate order for Intellisense to work well.


Profile

mellowtigger: (Default)
mellowtigger

About

September 2025

S M T W T F S
 1234 56
78910 111213
14 15 16 17181920
21222324252627
282930    

Most Popular Tags

Powered by Dreamwidth Studios
Page generated 2025-Sep-18, Thursday 07:36 am