feat: migrate to the full-temporary spaces

Summarize the changes

• feat: migrate to the full-temporary spaces

All materialized table on the storages are now fully temporary and do not leave any records in WAL. Statistics table are left data temporary as there is no need to recreate them on every restart.

Closes #353 (closed)

Ensure that

• New code is covered by unit and integration tests.
• Related issues would be automatically closed with gitlab's closing pattern (Closes #1, #2).
• Public modules are documented (check the rendered version with cargo doc --open).
• (if PEST grammar is changed) EBNF grammar reflects these changes (check the result with railroad diagram generator.

Next steps

• Update sbroad submodule in picodata/picodata.
• (if EBNF grammar is changed) create a follow-up issue in picodata/docs.