Currently, I’m using SQLKata for production. SQLKata not only supports us to save time with writing SQL commands but also protects us against SQL Injection attacks by default.

However, you should consider using SQLKata to write complex SQL commands like join multiple tables with many “where” conditions as it would lead to very hard to debug and maintain. With this case, I would suggest to use Store Procedure rather than SQLKata.

Hope this answers your question.