What do you use it for? What's the best part for you?
I'm currently using it to provide a SQL interface for doing data analytics for customers that don't have data large enough to justify a large platform like Snowflake or Databricks. Its syntax is close enough to the other two that, especially since the logic is already normalized through abstracted query definitions, it's a drop in replacement.
Given that it's so lightweight, I can use it run searches in an AWS Lambda function, which is crazy useful.
It is quite fast for OLAP applications. It works on low cost hardware.