Custom name for Enums still not possible

### Version Information

Server Version: 2.6.0-beta.1

### What is the expected behaviour?

Have the ability to set a custom enum name in the metadata and not have it changed by Hasura.

for example, making the custom enum name `Country` should amor be converted to `Country_enum`

Opening this ticket as requested in this comment https://github.com/hasura/graphql-engine/issues/8308#issuecomment-1097886419

### Keywords

Enum

### What is the current behaviour?

the `_enum` string is always suffixed

### Any possible solutions?

Just remove the suffix if there is a custom name.

### Can you identify the location in the source code where the problem exists?

Yes

### If the bug is confirmed, would you be willing to submit a PR?

Yes

No source file or test is named in the issue. Start by tracing how enum names from metadata are generated and where the `_enum` suffix is added; verify the behavior with a regression test showing that a custom name such as `Country` remains unchanged.

Written by the indexing model from the issue text.