Move things out of SQLBaseStore

This reverts commit 00f0d675.

Its going to get removed soon, so lets not make merge conflicts.

Fix issue #6406 parameter mismatch

Filter state, events_before and events_after in /context requests

Merge branch 'babolivier/context_filters' of github.com:matrix-org/synapse into babolivier/context_filters

Co-Authored-By: Erik Johnston <erik@matrix.org>

make cross signing signature index non-unique

Ensure that the the default settings for the room directory are that the it is hidden from public view by default. 

(hopefully)

... and deobfuscate the relevant bit of code.

Signed-off-by: Syam G Krishnan <syamgk@gmail.com>

Signed-off-by: Syam G Krishnan <syamgk01@gmail.com>

Implement part [MSC2228](https://github.com/matrix-org/matrix-doc/pull/2228). The parts that differ are:

* the feature is hidden behind a configuration flag (`enable_ephemeral_messages`)
* self-destruction doesn't happen for state events
* only implement support for the `m.self_destruct_after` field (not the `m.self_destruct` one)
* doesn't send synthetic redactions to clients because for this specific case we consider the clients to be able to destroy an event themselves, instead we just censor it (by pruning its JSON) in the database

Signed-Off-By: Filip Štědronský <g@regnarg.cz>

Implement MSC 2367 - Membership Reasons

Discard retention policies when retrieving state