non_block.md: add details on opcodes usage

Summary

• non_block.md: add details on opcodes consumption

---

• Close #290 (closed)
• Cherry-pick to: 24.4
• Staging: https://docs.binary.picodata.io/picodata/at_opcodes/reference/sql/non_block/