I have got a server written in C# dotnet and am trying to add Scripting Integration Lua to it. My issue is trying to add SQLite and MySQL. I'm using

luarocks install luasql-sqlite3 to add it but it's throwing an error:

Error: Could not find expected file sqlite3.h for SQLITE -- you may have to install SQLITE in your system and/or set the SQLITE_DIR variable

I've added SQLITE_DIR in Environment Variable to C:\sqlite, inside that folder contains sqlite3.h, sqlite3.def, sqlite3.dll, and other sqlite3 files, and if I write sqlite3 in the CMD it runs SQLite!

CMD showing SQLITE running through CMD using sqlite3

Note that I tried using
luarocks install luasql-sqlite3 SQLITE_VAR="C:/sqlite"
Add the sqlite3 files to LUA/5.1/include

I want to be able to use MySQL and SQLite in Lua within the C# project that I'm doing.