I'm wondering how aurora would behave with queries mixing read and write. For example, with something like "INSERT INTO my_table(field1, field2, field3, ...) S

I'm wondering how aurora would behave with queries mixing read and write. For example, with something like "INSERT INTO my_table(field1, field2, field3, ...) SELECT f1, f2, f3... from root_table WHERE ...", I'm wondering how it will spread the load across nodes.