If you want SQlite small, you can always modify the compilation flags accordingly. R is not the cup of tea of everybody, or usable in any cicrcumstances. For a PC usage, in Python base version for example, the more it can have common standard SQL instruction features (CTE, Window Functions, Statistic Functions), the better. Other solutions are sometimes free, but with a high cost/complexity of installation.