feat(sql): add support for substring

Summary

• feat(sql): add support for substring

---

• Close sbroad#741 (closed)
• Cherry-pick to: none
• Docs follow-up: docs#452 (closed)
• Changelog is updated