{

FunctionDocumentation::Description description

= "Returns whether the array contains the specified element, the map contains the specified key, or the JSON object contains the specified path.\n\n"

"For JSON, nested paths are supported using dot notation (e.g., 'a.b.c').\n\n"

"When the first argument is a constant array and the second argument is a column or expression, "

"`has(constant_array, column)` behaves like `column IN (constant_array)` and can use primary key "

"and data-skipping indexes for optimization. For example, `has([1, 10, 100], id)` can leverage "

"the primary key index if `id` is part of the `PRIMARY KEY`.\n\n"

"This optimization also applies when the column is wrapped in monotonic functions (e.g., `has([...], toDate(ts))`).";

FunctionDocumentation::Syntax syntax = "has(haystack, needle)";

FunctionDocumentation::Arguments arguments = {

{"haystack", "The source array, map, or JSON.", {"Array", "Map", "JSON"}},

{"needle", "The value to search for (element in array, key in map, or path string in JSON)."}

};

FunctionDocumentation::ReturnedValue returned_value = {"Returns `1` if the haystack contains the specified needle, otherwise `0`.", {"UInt8"}};

FunctionDocumentation::Examples examples = {

{"Array basic usage", "SELECT has([1, 2, 3], 2)", "1"},

{"Array not found", "SELECT has([1, 2, 3], 4)", "0"},

{"Map basic usage", "SELECT has(map('a', 1, 'b', 2), 'b')", "1"},

{"JSON path", R"(SELECT has('{"a": {"b": 1}}'::JSON, 'a.b'))", "1"}

};

FunctionDocumentation::IntroducedIn introduced_in = {1, 1};

FunctionDocumentation::Category category = FunctionDocumentation::Category::Array;

FunctionDocumentation documentation = {description, syntax, arguments, {}, returned_value, examples, introduced_in, category};

factory.registerFunction<FunctionHas>(documentation);