.flake8
.gitignore
CONTRIBUTING.md
LICENSE
README.md
pyproject.toml
pytest.ini
.github/workflows/publish-to-pypi.yml
.github/workflows/test.yml
examples/clickhouse_mcp_notebook.ipynb
examples/sql_magic_notebook.ipynb
src/dubai_real_estate/__init__.py
src/dubai_real_estate/_version.py
src/dubai_real_estate/install.py
src/dubai_real_estate.egg-info/PKG-INFO
src/dubai_real_estate.egg-info/SOURCES.txt
src/dubai_real_estate.egg-info/dependency_links.txt
src/dubai_real_estate.egg-info/requires.txt
src/dubai_real_estate.egg-info/top_level.txt
src/dubai_real_estate/connection/__init__.py
src/dubai_real_estate/connection/clients.py
src/dubai_real_estate/connection/manager.py
src/dubai_real_estate/connection/storage.py
src/dubai_real_estate/connection/types.py
src/dubai_real_estate/magic/__init__.py
src/dubai_real_estate/magic/sql_magic.py
src/dubai_real_estate/sql/__init__.py
src/dubai_real_estate/sql/parser.py
src/dubai_real_estate/sql_files/__init__.py
src/dubai_real_estate/sql_files/functions/__init__.py
src/dubai_real_estate/sql_files/functions/format/__init__.py
src/dubai_real_estate/sql_files/functions/format/format_type.sql
src/dubai_real_estate/sql_files/functions/lang/__init__.py
src/dubai_real_estate/sql_files/functions/lang/check.sql
src/dubai_real_estate/sql_files/functions/map/__init__.py
src/dubai_real_estate/sql_files/functions/map/activity_type_id.sql
src/dubai_real_estate/sql_files/functions/map/application_id.sql
src/dubai_real_estate/sql_files/functions/map/area_id.sql
src/dubai_real_estate/sql_files/functions/map/contract_reg_type_id.sql
src/dubai_real_estate/sql_files/functions/map/ejari_bus_property_type.sql
src/dubai_real_estate/sql_files/functions/map/ejari_property_type_id.sql
src/dubai_real_estate/sql_files/functions/map/escrow_agent_id.sql
src/dubai_real_estate/sql_files/functions/map/land_type_id.sql
src/dubai_real_estate/sql_files/functions/map/legal_status_id.sql
src/dubai_real_estate/sql_files/functions/map/legal_type_id.sql
src/dubai_real_estate/sql_files/functions/map/license_source_dev_id.sql
src/dubai_real_estate/sql_files/functions/map/license_source_id.sql
src/dubai_real_estate/sql_files/functions/map/license_type_id.sql
src/dubai_real_estate/sql_files/functions/map/main.sql
src/dubai_real_estate/sql_files/functions/map/market_types.sql
src/dubai_real_estate/sql_files/functions/map/master_community_id.sql
src/dubai_real_estate/sql_files/functions/map/nationality_id.sql
src/dubai_real_estate/sql_files/functions/map/nearest_landmark_id.sql
src/dubai_real_estate/sql_files/functions/map/nearest_mall_id.sql
src/dubai_real_estate/sql_files/functions/map/nearest_metro_id.sql
src/dubai_real_estate/sql_files/functions/map/parking_allocation_type_id.sql
src/dubai_real_estate/sql_files/functions/map/permit_status_id.sql
src/dubai_real_estate/sql_files/functions/map/procedure_id.sql
src/dubai_real_estate/sql_files/functions/map/project_classification_id.sql
src/dubai_real_estate/sql_files/functions/map/project_status_id.sql
src/dubai_real_estate/sql_files/functions/map/project_type_id.sql
src/dubai_real_estate/sql_files/functions/map/property_sub_type_id.sql
src/dubai_real_estate/sql_files/functions/map/property_type_id.sql
src/dubai_real_estate/sql_files/functions/map/property_usage_id.sql
src/dubai_real_estate/sql_files/functions/map/reg_type_id.sql
src/dubai_real_estate/sql_files/functions/map/request_source_id.sql
src/dubai_real_estate/sql_files/functions/map/rooms_id.sql
src/dubai_real_estate/sql_files/functions/map/service_category_id.sql
src/dubai_real_estate/sql_files/functions/map/service_id.sql
src/dubai_real_estate/sql_files/functions/map/status_id.sql
src/dubai_real_estate/sql_files/functions/map/tenant_type_id.sql
src/dubai_real_estate/sql_files/functions/map/trans_group_id.sql
src/dubai_real_estate/sql_files/functions/map/usage_id.sql
src/dubai_real_estate/sql_files/functions/map/zoning_authority_id.sql
src/dubai_real_estate/sql_files/functions/math/__init__.py
src/dubai_real_estate/sql_files/functions/math/cond.sql
src/dubai_real_estate/sql_files/tables/dld_accredited_escrow_agents/__init__.py
src/dubai_real_estate/sql_files/tables/dld_accredited_escrow_agents/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_accredited_escrow_agents/create.sql
src/dubai_real_estate/sql_files/tables/dld_accredited_escrow_agents/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_accredited_escrow_agents/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_accredited_escrow_agents/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_accredited_escrow_agents/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_brokers/__init__.py
src/dubai_real_estate/sql_files/tables/dld_brokers/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_brokers/create.sql
src/dubai_real_estate/sql_files/tables/dld_brokers/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_brokers/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_brokers/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_brokers/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_buildings/__init__.py
src/dubai_real_estate/sql_files/tables/dld_buildings/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_buildings/create.sql
src/dubai_real_estate/sql_files/tables/dld_buildings/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_buildings/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_buildings/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_buildings/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_developers/__init__.py
src/dubai_real_estate/sql_files/tables/dld_developers/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_developers/create.sql
src/dubai_real_estate/sql_files/tables/dld_developers/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_developers/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_developers/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_developers/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_free_zone_companies_licensing/__init__.py
src/dubai_real_estate/sql_files/tables/dld_free_zone_companies_licensing/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_free_zone_companies_licensing/create.sql
src/dubai_real_estate/sql_files/tables/dld_free_zone_companies_licensing/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_free_zone_companies_licensing/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_free_zone_companies_licensing/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_free_zone_companies_licensing/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_land_registry/__init__.py
src/dubai_real_estate/sql_files/tables/dld_land_registry/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_land_registry/create.sql
src/dubai_real_estate/sql_files/tables/dld_land_registry/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_land_registry/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_land_registry/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_land_registry/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_licenced_owner_associations/__init__.py
src/dubai_real_estate/sql_files/tables/dld_licenced_owner_associations/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_licenced_owner_associations/create.sql
src/dubai_real_estate/sql_files/tables/dld_licenced_owner_associations/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_licenced_owner_associations/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_licenced_owner_associations/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_licenced_owner_associations/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_map_requests/__init__.py
src/dubai_real_estate/sql_files/tables/dld_map_requests/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_map_requests/create.sql
src/dubai_real_estate/sql_files/tables/dld_map_requests/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_map_requests/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_map_requests/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_map_requests/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_oa_service_charges/__init__.py
src/dubai_real_estate/sql_files/tables/dld_oa_service_charges/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_oa_service_charges/create.sql
src/dubai_real_estate/sql_files/tables/dld_oa_service_charges/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_oa_service_charges/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_oa_service_charges/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_oa_service_charges/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_offices/__init__.py
src/dubai_real_estate/sql_files/tables/dld_offices/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_offices/create.sql
src/dubai_real_estate/sql_files/tables/dld_offices/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_offices/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_offices/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_offices/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_projects/__init__.py
src/dubai_real_estate/sql_files/tables/dld_projects/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_projects/create.sql
src/dubai_real_estate/sql_files/tables/dld_projects/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_projects/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_projects/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_projects/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_licenses/__init__.py
src/dubai_real_estate/sql_files/tables/dld_real_estate_licenses/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_licenses/create.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_licenses/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_licenses/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_licenses/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_licenses/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_permits/__init__.py
src/dubai_real_estate/sql_files/tables/dld_real_estate_permits/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_permits/create.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_permits/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_permits/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_permits/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_real_estate_permits/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_rent_contracts/__init__.py
src/dubai_real_estate/sql_files/tables/dld_rent_contracts/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_rent_contracts/create.sql
src/dubai_real_estate/sql_files/tables/dld_rent_contracts/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_rent_contracts/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_rent_contracts/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_rent_contracts/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_transactions/__init__.py
src/dubai_real_estate/sql_files/tables/dld_transactions/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_transactions/create.sql
src/dubai_real_estate/sql_files/tables/dld_transactions/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_transactions/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_transactions/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_transactions/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_units/__init__.py
src/dubai_real_estate/sql_files/tables/dld_units/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_units/create.sql
src/dubai_real_estate/sql_files/tables/dld_units/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_units/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_units/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_units/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_valuation/__init__.py
src/dubai_real_estate/sql_files/tables/dld_valuation/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_valuation/create.sql
src/dubai_real_estate/sql_files/tables/dld_valuation/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_valuation/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_valuation/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_valuation/prod_view.sql
src/dubai_real_estate/sql_files/tables/dld_valuator_licensing/__init__.py
src/dubai_real_estate/sql_files/tables/dld_valuator_licensing/clean_view.sql
src/dubai_real_estate/sql_files/tables/dld_valuator_licensing/create.sql
src/dubai_real_estate/sql_files/tables/dld_valuator_licensing/create_prod.sql
src/dubai_real_estate/sql_files/tables/dld_valuator_licensing/ingest.sql
src/dubai_real_estate/sql_files/tables/dld_valuator_licensing/ingest_prod.sql
src/dubai_real_estate/sql_files/tables/dld_valuator_licensing/prod_view.sql
tests/__init__.py
tests/conftest.py
tests/integration/__init__.py
tests/integration/test_clickhouse_integration.py
tests/integration/sql_functions/__init__.py
tests/integration/sql_functions/test_format.py
tests/integration/sql_functions/test_lang.py
tests/integration/sql_functions/test_maps.py
tests/integration/sql_functions/tests_math.py
tests/integration/sql_tables/__init__.py
tests/integration/sql_tables/test_create_ingest.py
tests/unit/__init__.py
tests/unit/test_connection.py