package Kedro project should return session.run

[noklam]

The problem with the main() method is that it currently returns an exit code, so downstream processes can't do anything with it.

Clarify this one a bit. I think these are 2 problems

1. main should return the session.run() - so downstream processing is possible
2. click generate a sys.exit() by default, and since main wrap around the CLI so it creates some issue on Databricks or even just IPython - this link explains more.

Originally posted by @noklam in #1423 (comment)

https://github.com/kedro-org/kedro-starters/blob/ef88b095119e050161dab5e593f184eaf11b1af0/pandas-iris/%7B%7B%20cookiecutter.repo_name%20%7D%7D/src/%7B%7B%20cookiecutter.python_package%20%7D%7D/__main__.py#L39-L43C10

def main(*args, **kwargs):
    package_name = Path(__file__).parent.name
    configure_project(package_name)
    run = _find_run_command(package_name)
    run(*args, **kwargs)

This currently doesn't return anything

[astrojuanlu]

Related: #2682 (comment)

[noklam]

Pre-requisite: #2682