[Bug?]: yarn 1.22.19 forces dependency on node 18

[amiramix]

Self-service

• I'd be willing to implement a fix

Describe the bug

Executing 'npx yarn install' with the following package.json (see later) results in an error:

Grzegorzs-MacBook-Pro:yarn-test g$ npx yarn install
yarn install v1.22.19
info No lockfile found.
[1/4] 🔍  Resolving packages...
warning lerna > @lerna/create > pacote > cacache > @npmcli/[email protected]: This functionality has been moved to @npmcli/fs
warning lerna > @lerna/bootstrap > @npmcli/arborist > @npmcli/[email protected]: This functionality has been moved to @npmcli/fs
warning lerna > @lerna/bootstrap > @npmcli/arborist > [email protected]: This functionality has been moved to @npmcli/fs
warning lerna > @lerna/bootstrap > @npmcli/arborist > readdir-scoped-modules > [email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
[2/4] 🚚  Fetching packages...
error @yarnpkg/[email protected]: The engine "node" is incompatible with this module. Expected version ">=18.12.0". Got "14.19.3"
error Found incompatible module.
info Visit https://yarnpkg.com/en/docs/cli/install for documentation about this command.

To reproduce

1. Switch to node 14 (tested with 14.19.3 and 14.21.3)

2. Create a folder with just one file, the following package.json:

Grzegorzs-MacBook-Pro:yarn-test g$ cat package.json 
{
  "name": "yarn-test",
  "description": "Simple app to reproduce issue with yarn install",
  "private": true,
  "browserslist": [
    "defaults",
    "not IE 11"
  ],
  "workspaces": [
    "packages/*"
  ],
  "scripts": {
    "i": "yarn install"
  },
  "devDependencies": {
    "lerna": "6.1.0"
  }
}

3. CD to the folder and execute: npx yarn install

Environment

macOS 12.6.7
Processor Intel Core i7
node 14.19.3
npm 6.14.17

Additional context

No response

[igorbojk]

The same situation.

@yarnpkg/[email protected]: The engine "node" is incompatible with this module. Expected version ">=18.12.0". Got "16.20.0"
Hope the fix will be ASAP, because we cant to change the node version in our project.

[arcanis]

Duplicate with #5542