synapse refuses to start against sqlite unless sqlite supports json extension

This issue has been migrated from [#7218](https://github.com/matrix-org/synapse/issues/7218).

---

### Description
Twisted test suite doesn't pass after fresh clone and install

### Steps to reproduce
Steps from the Synapse Development portion of the README
- git clone https://github.com/matrix-org/synapse.git
- cd synapse

- virtualenv -p python3 env
- source env/bin/activate
python -m pip install --no-use-pep517 -e ".[all]"
python -m twisted.trial tests

Ran 907 tests in 41.853s
FAILED (skips=1, errors=610, successes=296)

I guess I was expecting them to pass off a fresh clone, is there something I'm doing wrong? Thanks!

### Version information

- **Homeserver**:

If not matrix.org:

- **Version**:

- **Install method**:

- **Platform**: