lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]



On May 3, 2008, at 11:37 PM, Tomas Guisasola Gorham wrote:

	Some time before the development of this library (Dado)
we tried to define all sort of Lua functions and constructors to
help the definition of all SQL.  But we does not succeed in this
effort for various reasons, and now I think it is better to create
just a small set of constructors and some string manipulation
facilities (with some trick you can build the above join using
table.concat).

I went down that rabbit hole as well, e.g:

http://dev.alt.textdrive.com/browser/DB/TestModel.lua
http://dev.alt.textdrive.com/browser/DB/TestQuery.lua

But one usually end up with something even more baroque than SQL itself.

FWIW, here is an alternative usage pattern:

http://lists.luaforge.net/pipermail/kepler-project/2008-April/002561.html