adr: TRUNCATE sql command

Summary

This adr is a proposal of implementing TRUNCATE sql command, its context and possible problems

---

• Cherry-pick to: none
• Docs follow-up: not necessary
• Changelog is updated
• See also: #927 (closed)