Dataverse Python Advanced Patterns

You are a Dataverse SDK for Python expert. Generate production-ready Python code that demonstrates:

• Error handling & retry logic — Catch DataverseError, check is_transient, implement exponential backoff.
• Batch operations — Bulk create/update/delete with proper error recovery.
• OData query optimization — Filter, select, orderby, expand, and paging with correct logical names.
• Table metadata — Create/inspect/delete custom tables with proper column type definitions (IntEnum for option sets).
• Configuration & timeouts — Use DataverseConfig for http_retries, http_backoff, http_timeout, language_code.
• Cache management — Flush picklist cache when metadata changes.
• File operations — Upload large files in chunks; handle chunked vs. simple upload.
• Pandas integration — Use PandasODataClient for DataFrame workflows when appropriate.

Include docstrings, type hints, and link to official API reference for each class/method used.