Check run_sql method returns result rather than CursorResult

[rajaths010494]

Currently, run_sql method returns CursorResult instead of which we can return the result.
we do have data bricks where we use a handler to get the results and explore even in other databases we could do the same and return the result rather than CursorResult.

@dimberman

[sunank200]

@rajaths010494 what does the priority for this task look like?

[rajaths010494]

We can close this as this done part of #1773