feat(sql): support selects without scans

Summary

• feat(sql): support selects without scans

---

• Cherry-pick to: none
• Docs follow-up: docs#372 (closed)
• Depends on sbroad!524 (merged)