August 26th, 2004

  • evan

sql

Why do we use SQL? It seems every serious user of SQL has some abstraction layer on top of the language, either DBI-style quoting (select x from y where z=?) or a fancier object layer. I recall that at least for compilation the lexing step takes a significant fraction of the processing time. So why not feed the database some sort of preparsed/binary query, and make this human-friendly text interface just part of a frontend that converts to database-speak? (See also: Graydon's work on an SQL extension for OCaml, which would have made it a compile-time error to generate a malformed query.)