SqlKata is highly praised for its ability to simplify and streamline the process of building dynamic SQL queries in .NET applications. Users appreciate its ease of use, flexibility, and the time it saves by minimizing the need to write repetitive SQL statements manually. The library is noted for its efficient query building, low learning curve, and extensibility, with some users even creating custom extensions. It is particularly valued for projects utilizing Dapper, offering protection against SQL injection and near-raw query performance. However, some users have expressed a need for more documentation.