[Feature](lance) Support additional vector index algorithms

## Parent

Tracked by #66340. IVF_PQ query support was introduced and verified by #65730.

## Scope

- [ ] IVF_FLAT query support.
- [ ] IVF_SQ query support.
- [ ] IVF_HNSW_FLAT query support.
- [ ] IVF_HNSW_SQ query support.
- [ ] IVF_HNSW_PQ query support.
- [ ] Define compatible vector element types, distance metrics, and ANN tuning parameters for each algorithm.

## Completion criteria

- [ ] Query execution works through Lance automatic index selection for every listed algorithm.
- [ ] Regression fixtures and tests cover every algorithm and compatible metric combination.
- [ ] EXPLAIN and error handling make index selection and incompatibilities diagnosable.
- [ ] User documentation contains a supported algorithm compatibility matrix.