Add SQL query planner support for scalar subqueries

[andygrove]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.
Add SQL query planner support for scalar subqueries

Describe the solution you'd like
Add SQL query planner support for scalar subqueries

Describe alternatives you've considered
None

Additional context
None