Check `is_operable` for each DML

Summary

For each DML check if table is operable for global and sharded tables

• Close #530 (closed)
• Cherry-pick to: 24.6
• Docs follow-up: not necessary
• Changelog is updated

Closes #530 (closed)