Autocast Strings to Int for Enum for JSON

[gingerwizard]

Use case

CREATE TABLE test
(
    `answer` Enum8('Question' = 1, 'Answer' = 2, 'Wiki' = 3, 'TagWikiExcerpt' = 4, 'TagWiki' = 5, 'ModeratorNomination' = 6, 'WikiPlaceholder' = 7, 'PrivilegeWiki' = 8)
)
ENGINE = Memory

INSERT INTO test FORMAT JSONEachRow {"answer": 1}

Ok.


INSERT INTO test FORMAT JSONEachRow {"answer": "1"}

Ok.
Exception on client:
Code: 691. DB::Exception: Unknown element '1' for enum: (while reading the value of key answer): (at row 1)
: While executing ParallelParsingBlockInputFormat: data for INSERT was parsed from query. (UNKNOWN_ELEMENT_OF_ENUM)

Describe the solution you'd like

A setting which enables cast as Int prior to insert so this works.

[Blargian]

@Avogar I'd like to work on this one