When would you use query by example?

In your experience, can you elaborate on specific scenarios where utilizing the technique of query by example would be advantageous? What kind of challenges or data exploration tasks does it typically facilitate, and how does it help streamline the querying process for practitioners in the cryptocurrency and finance realm?