Yes, would like this too ! (But do not know, how to achieve this ...)
I think that simplifying the task of storing data in org-tables would allow many interesting org-applications to be implemented more easily. And thanks for pointing at cvsql; will have a look. best regards, Marc Am 18.08.2013 16:06, schrieb Johan W. Klüwer:
I wish it were possible to execute SQL on tables in org-mode buffers. Filtering rows and columns, joining values across named tables, and so forth could be done with SQL in the org-table SEND clauses. There's a script called csvsql that allows for executing SQL on comma- or tab-separated files from the command-line (using the H2 database engine): https://github.com/jdurbin/durbinlib/wiki/csvsql. I'm thinking csvsql or similar could provide the query capability, and org-mode would take care of sending it org tables in tab separated format. That's my wish. Cheers Johan