Databricks Genie is excellent from my experience, and provides for all your listed requirements.