Dynamic Search Filter Engine

Build a backend library that takes a complex, nested JSON representation of search filters (e.g., '(Category: Electronics AND Price < 500) OR (Brand: Sony AND Rating > 4)') and translates it into different target formats: SQL WHERE clauses, Elasticsearch Query DSL, and a Mock In-Memory Filter for unit testing. The system must be easily extensible to support new filter types (e.g., Geo-location) without modifying the core translation logic.