Datacube 1.9.0-rc3 pre-release

This is re-pre-release of 1.9.0-rc1 to get the github and pypi pre-release version numbering back in sync.

Datacube 1.9.0 release candidate 3

The last new major release of the Open Data Cube was v1.8.0 in May 2020, nearly 4 years ago.

ODC developers and the Steering Council have been working hard behind the scenes over the last couple of years
to address some of the accumulated technical debt in datacube-core and prepare for new major releases.

The long-term plan includes a number of significant backwards-incompatible changes. An effort has been made to
provide a smooth migration pathway wherever possible, with existing behaviour in 1.8.x versions being deprecated
in 1.9.x, with alternatives being provided, then removing the deprecated behaviour in 2.0.x with the alternative
approaches becoming the standard, but some minor backwards incompatible changes in 1.9.x were unavoidable.

This is the first release candidate for the 1.9.x release series. Please refer to the Migration Notes document before attempting to upgrade from a 1.8 series installation.

• Merge in 1.8.x branch changes. (#1459, #1473, #1532, #1548, #1565)
• External Lineage API (#1401)
• Add lineage support to index clone operation (#1429)
• Migrate to SQLAlchemy 2.0 (#1432)
• Clean up deprecated code and add deprecation warnings to legacy methods, simplify DocReader logic (#1406)
• Mark geometry module as deprecated and replace all usage with odc-geo (#1424)
• Mark GridSpec as deprecated, replace math and cog functions with odc-geo equivalents, enforce new odc-geo conventions (#1441)
• Rename gbox to geobox in parameter names (#1441)
• Remove executor API (#1462)
• Remove ingestion methods, GridWorkflow and Tile classes (#1465)
• Fix postgis queries for numeric custom search fields (#1475)
• Document best practice for pulling in changes from develop and update constraints.txt (#1478)
• Postgis index driver performance tuning (#1480)
• Cleanup and formalise spatial index API and expose in CLI (#1481)
• Increase minimum Python version to 3.10 (#1509)
• Virtual product tests using odc-geo GridSpec (#1512)
• New Configuration API, as per ODC-EP10 (#1505)
• Alembic migrations for postgis driver (#1520)
• EP08 lineage extensions/changes to datasets.get(). (#1530)
• EP13 API changes to Index and IndexDriver. (#1534)
• EP13 API changes to metadata and product resources. (#1536)
• Phase 1 of EP13 API changes to dataset resource - get_unsafe, get_derived, temporal_extent. (#1538)
• Add product argument to spatial_extent method, as per EP13. (#1539)
• Index driver API type hint cleanup. (#1541)
• Deprecate multiple locations. (#1546)
• Deprecate search_eager and search_summaries and add archived arg to all dataset search/count methods. (#1550)
• Migrate away from deprecated Python pkg_resources module (#1558)
• Add custom_offsets and order_by arguments to search_retunrning() - order_by still unimplemented. (#1557)
• Fix and enhance typehints, automated static type checking with mypy. (#1562)
• Improve SQLAlchemy join hints, addressing an recurring but intermittent bug. (#1564)
• Improve typehints and update docstrings in datacube/api/core.py (#1567)
• Add migration notes, update documentation and whats_new.rst for 1.9.0-rc1 release (#1569)

Includes contributions from @SpacemanPaul and @Ariana-B, with assistance from @omad and @robbibt

With thanks to the Open Data Cube Steering Council and all supporting organisations, especially Geoscience Australia.