Finalize release process

[janbuchar]

• follow up to ci: autogenerate changelog #330

• make sure that manual releases work

• add commit authors to changelog

• accept patch/minor/major as the release type #388

• ensure that pyproject.toml contains the correct semver in release workflow

• include info about closed issues in the changelog

• restore PyPI pre-releases (I messed up dependencies)

• remove as many homebaked scripts as possible

[janbuchar]

Here's a way to find issues closed by a PR

gh api graphql --paginate --slurp -F owner='apify' -F repo='crawlee-python' -f query='
query ($owner: String!, $repo: String!, $endCursor: String) {
        repository(owner: $owner, name: $repo) {
                pullRequests(first: 100, after: $endCursor) {
                        nodes {
                                number,
                                closingIssuesReferences(last: 100) {
                                        nodes { number }
                                }
                        }
                        pageInfo {
                                hasNextPage
                                endCursor
                        }
                }
        }
}' | jq '[.[] | .data.repository.pullRequests.nodes ] | flatten[] | {pullRequest: .number, closedIssues: [.closingIssuesReferences.nodes | .[] | .number] }' | jless