Whenever you're ready, walk me through how you'd approach this.
Design an in-memory SQL database.
You may assume the database stores relational tables in process memory and supports a practical subset of SQL. Explain the architecture and implementation plan, including parsing, query execution, indexes, mutations, transactions, and testing. Clarify any syntax or consistency limitations you choose.