fix(api): use to_pyarrow() instead of execute() when pretty printing scalars

fix(api): use to_pyarrow() instead of execute() when pretty printing scalars #6355