https://www.techempower.com/benchmarks/#section=data-r10&hw=...
https://www.techempower.com/benchmarks/#section=data-r10&hw=...
Try searching a driver for a not so popular db on npm and you might find two different implementations in addition to the official driver.
I'd love to see something like this on openresty.
Yeah. There are "Lua rocks" (https://luarocks.org/) for Lua, but they have a few hundreds of packages only. Compared to npm there's no comparison at all.
On the other hand you wouldn't want to use RDBMS with OpenResty anyway, I think. The whole point of using Nginx scripting (especially with LuaJIT, which is awesome) is to be as fast as possible. True, DB connections are async in Resty, but they are still going to take some time. For simple data that don't need to be persistent it's better to use ngx.shared - an in process dictionary shared between all scripts. For more complicated or persistent data, you have Redis and other fast solutions.
Additionally, Nginx offers a full non-blocking socket API to Lua scripts. You can write a "driver" for anything that wants to speak to you over a network.
There continually seems to be this belief that Lua is language only for game scripting; outside of that it is largely ignored.
Using your same link I find this solution blowing node away in JSON serialization but the other benchmarks? Not so much. In fact complete opposite for some of them.
As far as I have found there is no "best at everything" language and framework so your binary question doesn't make much sense. I'm also not convinced of this solution in a large web application because debugging and unit testing would be nightmare .
So, it's a bit more inconclusive than you describe. I'd expect OpenResty to be much faster than Node for a lot of common web interactions. Node has better support for interacting with external services asynchronously, though.
The creator of OpenResty has expressed interest in eventually extending it to work for non-HTTP usecases though.