I would really like to be able to pull data directly from ODBC databases into LuaLaTeX and it seems as if the LuaSQL package is the way to go. But for the life of me, after a couple of days of trying, I cannot get it to install, even for a standalone Lua installation.
I have tried installing via luarocks - which required me to install Visual Studio 2015 and the Windows 10 SDK for headers etc. - but I can't get it to compile. Lots of messing about trying to make sure there weren't any spaces in folder names, for example, but to no avail.
I have also tried using the Windows binaries available from luaforge.net despite their 2005 date, but can't get lua to load them ("The specified module could not be found").
Is anyone using Lua(La)TeX with LuaSQL successfully? If so, would you mind sharing how you did it?!