Are Dynamic tables backed by rocksdb?

[kant kodali]

Hi All,

Are Dynamic tables backed by Rocksdb or in memory? if they are backed by
RocksDB can I use SQL to query the state?

Thanks!