Function findByType

Type Parameters

• T extends
      | "boolean"
      | "function"
      | "column"
      | "date"
      | "time"
      | "timestamp"
      | "interval"
      | "uuid"
      | "array"
      | "list"
      | "struct"
      | "map"
      | "set"
      | "union"
      | "byte_string"
      | "datetime"
      | "literal"
      | "null"
      | "identifier"
      | "table"
      | "star"
      | "braced_wildcard"
      | "select"
      | "intersect"
      | "except"
      | "subquery"
      | "pivot"
      | "pivot_alias"
      | "unpivot"
      | "values"
      | "pre_where"
      | "stream"
      | "using_data"
      | "xml_namespace"
      | "insert"
      | "update"
      | "delete"
      | "copy"
      | "put"
      | "stage_reference"
      | "alias"
      | "cast"
      | "collation"
      | "case"
      | "and"
      | "or"
      | "add"
      | "sub"
      | "mul"
      | "div"
      | "mod"
      | "eq"
      | "neq"
      | "lt"
      | "lte"
      | "gt"
      | "gte"
      | "like"
      | "i_like"
      | "match"
      | "bitwise_and"
      | "bitwise_or"
      | "bitwise_xor"
      | "concat"
      | "adjacent"
      | "ts_match"
      | "property_e_q"
      | "array_contains_all"
      | "array_contained_by"
      | "array_overlaps"
      | "j_s_o_n_b_contains_all_top_keys"
      | "j_s_o_n_b_contains_any_top_keys"
      | "j_s_o_n_b_delete_at_path"
      | "extends_left"
      | "extends_right"
      | "not"
      | "neg"
      | "bitwise_not"
      | "in"
      | "between"
      | "is_null"
      | "is_true"
      | "is_false"
      | "is_json"
      | "is"
      | "exists"
      | "member_of"
      | "aggregate_function"
      | "window_function"
      | "from"
      | "join"
      | "joined_table"
      | "where"
      | "group_by"
      | "having"
      | "order_by"
      | "limit"
      | "offset"
      | "qualify"
      | "with"
      | "cte"
      | "distribute_by"
      | "cluster_by"
      | "sort_by"
      | "lateral_view"
      | "hint"
      | "pseudocolumn"
      | "connect"
      | "prior"
      | "connect_by_root"
      | "match_recognize"
      | "ordered"
      | "window"
      | "over"
      | "within_group"
      | "data_type"
      | "tuple"
      | "concat_ws"
      | "substring"
      | "upper"
      | "lower"
      | "length"
      | "trim"
      | "l_trim"
      | "r_trim"
      | "replace"
      | "reverse"
      | "left"
      | "right"
      | "repeat"
      | "lpad"
      | "rpad"
      | "split"
      | "regexp_like"
      | "regexp_replace"
      | "regexp_extract"
      | "overlay"
      | "abs"
      | "round"
      | "floor"
      | "ceil"
      | "power"
      | "sqrt"
      | "cbrt"
      | "ln"
      | "log"
      | "exp"
      | "sign"
      | "greatest"
      | "least"
      | "current_date"
      | "current_time"
      | "current_timestamp"
      | "current_timestamp_l_t_z"
      | "at_time_zone"
      | "date_add"
      | "date_sub"
      | "date_diff"
      | "date_trunc"
      | "extract"
      | "to_date"
      | "to_timestamp"
      | "date_from_unix_date"
      | "unix_date"
      | "unix_seconds"
      | "unix_millis"
      | "unix_micros"
      | "unix_to_time_str"
      | "time_str_to_date"
      | "date_to_di"
      | "di_to_date"
      | "ts_or_di_to_di"
      | "ts_or_ds_to_datetime"
      | "ts_or_ds_to_timestamp"
      | "year_of_week"
      | "year_of_week_iso"
      | "coalesce"
      | "null_if"
      | "if_func"
      | "if_null"
      | "nvl"
      | "nvl2"
      | "try_cast"
      | "safe_cast"
      | "count"
      | "sum"
      | "avg"
      | "min"
      | "max"
      | "group_concat"
      | "string_agg"
      | "list_agg"
      | "array_agg"
      | "count_if"
      | "sum_if"
      | "stddev"
      | "stddev_pop"
      | "stddev_samp"
      | "variance"
      | "var_pop"
      | "var_samp"
      | "median"
      | "mode"
      | "first"
      | "last"
      | "any_value"
      | "approx_distinct"
      | "approx_count_distinct"
      | "approx_percentile"
      | "percentile"
      | "logical_and"
      | "logical_or"
      | "skewness"
      | "bitwise_count"
      | "array_concat_agg"
      | "array_unique_agg"
      | "bool_xor_agg"
      | "row_number"
      | "rank"
      | "dense_rank"
      | "n_tile"
      | "lead"
      | "lag"
      | "first_value"
      | "last_value"
      | "nth_value"
      | "percent_rank"
      | "cume_dist"
      | "percentile_cont"
      | "percentile_disc"
      | "contains"
      | "starts_with"
      | "ends_with"
      | "position"
      | "initcap"
      | "ascii"
      | "chr"
      | "char_func"
      | "soundex"
      | "levenshtein"
      | "byte_length"
      | "hex"
      | "lower_hex"
      | "unicode"
      | "mod_func"
      | "random"
      | "rand"
      | "trunc_func"
      | "pi"
      | "radians"
      | "degrees"
      | "sin"
      | "cos"
      | "tan"
      | "asin"
      | "acos"
      | "atan"
      | "atan2"
      | "is_nan"
      | "is_inf"
      | "int_div"
      | "decode"
      | "date_format"
      | "format_date"
      | "year"
      | "month"
      | "day"
      | "hour"
      | "minute"
      | "second"
      | "day_of_week"
      | "day_of_week_iso"
      | "day_of_month"
      | "day_of_year"
      | "week_of_year"
      | "quarter"
      | "add_months"
      | "months_between"
      | "last_day"
      | "next_day"
      | "epoch"
      | "epoch_ms"
      | "from_unixtime"
      | "unix_timestamp"
      | "make_date"
      | "make_timestamp"
      | "timestamp_trunc"
      | "time_str_to_unix"
      | "session_user"
      | "s_h_a"
      | "s_h_a1_digest"
      | "time_to_unix"
      | "array_func"
      | "array_length"
      | "array_size"
      | "cardinality"
      | "array_contains"
      | "array_position"
      | "array_append"
      | "array_prepend"
      | "array_concat"
      | "array_sort"
      | "array_reverse"
      | "array_distinct"
      | "array_join"
      | "array_to_string"
      | "unnest"
      | "explode"
      | "explode_outer"
      | "array_filter"
      | "array_transform"
      | "array_flatten"
      | "array_compact"
      | "array_intersect"
      | "array_union"
      | "array_except"
      | "array_remove"
      | "array_zip"
      | "sequence"
      | "generate"
      | "exploding_generate_series"
      | "to_array"
      | "star_map"
      | "struct_func"
      | "struct_extract"
      | "named_struct"
      | "map_func"
      | "map_from_entries"
      | "map_from_arrays"
      | "map_keys"
      | "map_values"
      | "map_contains_key"
      | "map_concat"
      | "element_at"
      | "transform_keys"
      | "transform_values"
      | "json_extract"
      | "json_extract_scalar"
      | "json_extract_path"
      | "json_array"
      | "json_object"
      | "json_query"
      | "json_value"
      | "json_array_length"
      | "json_keys"
      | "json_type"
      | "parse_json"
      | "to_json"
      | "json_set"
      | "json_insert"
      | "json_remove"
      | "json_merge_patch"
      | "json_array_agg"
      | "json_object_agg"
      | "convert"
      | "typeof"
      | "lambda"
      | "parameter"
      | "placeholder"
      | "named_argument"
      | "table_argument"
      | "sql_comment"
      | "null_safe_eq"
      | "null_safe_neq"
      | "glob"
      | "similar_to"
      | "any"
      | "all"
      | "overlaps"
      | "bitwise_left_shift"
      | "bitwise_right_shift"
      | "bitwise_and_agg"
      | "bitwise_or_agg"
      | "bitwise_xor_agg"
      | "subscript"
      | "dot"
      | "method_call"
      | "array_slice"
      | "create_table"
      | "drop_table"
      | "alter_table"
      | "create_index"
      | "drop_index"
      | "create_view"
      | "drop_view"
      | "alter_view"
      | "alter_index"
      | "truncate"
      | "use"
      | "cache"
      | "uncache"
      | "load_data"
      | "pragma"
      | "grant"
      | "revoke"
      | "comment"
      | "set_statement"
      | "create_schema"
      | "drop_schema"
      | "drop_namespace"
      | "create_database"
      | "drop_database"
      | "create_function"
      | "drop_function"
      | "create_procedure"
      | "drop_procedure"
      | "create_sequence"
      | "drop_sequence"
      | "alter_sequence"
      | "create_trigger"
      | "drop_trigger"
      | "create_type"
      | "drop_type"
      | "describe"
      | "show"
      | "command"
      | "kill"
      | "execute"
      | "raw"
      | "paren"
      | "annotated"
      | "refresh"
      | "locking_statement"
      | "sequence_properties"
      | "truncate_table"
      | "clone"
      | "attach"
      | "detach"
      | "install"
      | "summarize"
      | "declare"
      | "declare_item"
      | "heredoc"
      | "set_item"
      | "query_band"
      | "user_defined_function"
      | "recursive_with_search"
      | "projection_def"
      | "table_alias"
      | "hex_string_expr"
      | "unicode_string"
      | "column_position"
      | "column_def"
      | "alter_column"
      | "alter_sort_key"
      | "alter_set"
      | "rename_column"
      | "comprehension"
      | "merge_tree_t_t_l_action"
      | "merge_tree_t_t_l"
      | "index_constraint_option"
      | "column_constraint"
      | "period_for_system_time_constraint"
      | "case_specific_column_constraint"
      | "character_set_column_constraint"
      | "check_column_constraint"
      | "compress_column_constraint"
      | "date_format_column_constraint"
      | "ephemeral_column_constraint"
      | "with_operator"
      | "generated_as_identity_column_constraint"
      | "auto_increment_column_constraint"
      | "comment_column_constraint"
      | "generated_as_row_column_constraint"
      | "index_column_constraint"
      | "masking_policy_column_constraint"
      | "not_null_column_constraint"
      | "primary_key_column_constraint"
      | "unique_column_constraint"
      | "watermark_column_constraint"
      | "computed_column_constraint"
      | "in_out_column_constraint"
      | "default_column_constraint"
      | "path_column_constraint"
      | "constraint"
      | "export"
      | "filter"
      | "changes"
      | "copy_parameter"
      | "credentials"
      | "directory"
      | "foreign_key"
      | "column_prefix"
      | "primary_key"
      | "into_clause"
      | "join_hint"
      | "opclass"
      | "index"
      | "index_parameters"
      | "conditional_insert"
      | "multitable_inserts"
      | "on_conflict"
      | "on_condition"
      | "returning"
      | "introducer"
      | "partition_range"
      | "fetch"
      | "group"
      | "cube"
      | "rollup"
      | "grouping_sets"
      | "limit_options"
      | "lateral"
      | "table_from_rows"
      | "rows_from"
      | "match_recognize_measure"
      | "with_fill"
      | "property"
      | "grant_privilege"
      | "grant_principal"
      | "allowed_values_property"
      | "algorithm_property"
      | "auto_increment_property"
      | "auto_refresh_property"
      | "backup_property"
      | "build_property"
      | "block_compression_property"
      | "character_set_property"
      | "checksum_property"
      | "collate_property"
      | "data_blocksize_property"
      | "data_deletion_property"
      | "definer_property"
      | "dist_key_property"
      | "distributed_by_property"
      | "dist_style_property"
      | "duplicate_key_property"
      | "engine_property"
      | "to_table_property"
      | "execute_as_property"
      | "external_property"
      | "fallback_property"
      | "file_format_property"
      | "credentials_property"
      | "freespace_property"
      | "inherits_property"
      | "input_model_property"
      | "output_model_property"
      | "isolated_loading_property"
      | "journal_property"
      | "language_property"
      | "enviroment_property"
      | "clustered_by_property"
      | "dict_property"
      | "dict_range"
      | "on_cluster"
      | "like_property"
      | "location_property"
      | "lock_property"
      | "locking_property"
      | "log_property"
      | "materialized_property"
      | "merge_block_ratio_property"
      | "on_property"
      | "on_commit_property"
      | "partitioned_by_property"
      | "partitioned_by_bucket"
      | "partition_by_truncate"
      | "partition_by_range_property"
      | "partition_by_range_property_dynamic"
      | "partition_by_list_property"
      | "partition_list"
      | "partition"
      | "refresh_trigger_property"
      | "unique_key_property"
      | "rollup_property"
      | "partition_bound_spec"
      | "partitioned_of_property"
      | "remote_with_connection_model_property"
      | "returns_property"
      | "row_format_property"
      | "row_format_delimited_property"
      | "row_format_serde_property"
      | "query_transform"
      | "sample_property"
      | "security_property"
      | "schema_comment_property"
      | "semantic_view"
      | "serde_properties"
      | "set_property"
      | "sharing_property"
      | "set_config_property"
      | "settings_property"
      | "sort_key_property"
      | "sql_read_write_property"
      | "sql_security_property"
      | "stability_property"
      | "storage_handler_property"
      | "temporary_property"
      | "tags"
      | "transform_model_property"
      | "transient_property"
      | "using_template_property"
      | "view_attribute_property"
      | "volatile_property"
      | "with_data_property"
      | "with_journal_table_property"
      | "with_schema_binding_property"
      | "with_system_versioning_property"
      | "with_procedure_options"
      | "encode_property"
      | "include_property"
      | "properties"
      | "input_output_format"
      | "reference"
      | "query_option"
      | "with_table_hint"
      | "index_table_hint"
      | "historical_data"
      | "get"
      | "set_operation"
      | "var"
      | "version"
      | "schema"
      | "lock"
      | "table_sample"
      | "tag"
      | "unpivot_columns"
      | "window_spec"
      | "session_parameter"
      | "pseudo_type"
      | "object_identifier"
      | "transaction"
      | "commit"
      | "rollback"
      | "alter_session"
      | "analyze"
      | "analyze_statistics"
      | "analyze_histogram"
      | "analyze_sample"
      | "analyze_list_chained_rows"
      | "analyze_delete"
      | "analyze_with"
      | "analyze_validate"
      | "add_partition"
      | "attach_option"
      | "drop_partition"
      | "replace_partition"
      | "d_pipe"
      | "operator"
      | "pivot_any"
      | "aliases"
      | "at_index"
      | "from_time_zone"
      | "format_phrase"
      | "for_in"
      | "time_unit"
      | "interval_op"
      | "interval_span"
      | "having_max"
      | "cosine_distance"
      | "dot_product"
      | "euclidean_distance"
      | "manhattan_distance"
      | "jarowinkler_similarity"
      | "booland"
      | "boolor"
      | "parameterized_agg"
      | "arg_max"
      | "arg_min"
      | "approx_top_k"
      | "approx_top_k_accumulate"
      | "approx_top_k_combine"
      | "approx_top_k_estimate"
      | "approx_top_sum"
      | "approx_quantiles"
      | "minhash"
      | "farm_fingerprint"
      | "float64"
      | "transform"
      | "translate"
      | "grouping"
      | "grouping_id"
      | "anonymous"
      | "anonymous_agg_func"
      | "combined_agg_func"
      | "combined_parameterized_agg"
      | "hash_agg"
      | "hll"
      | "apply"
      | "to_boolean"
      | "to_map"
      | "pad"
      | "to_char"
      | "to_number"
      | "to_double"
      | "int64"
      | "string_func"
      | "to_decfloat"
      | "try_to_decfloat"
      | "to_file"
      | "columns"
      | "convert_to_charset"
      | "convert_timezone"
      | "generate_series"
      | "a_i_agg"
      | "a_i_classify"
      | "array_all"
      | "array_any"
      | "array_construct_compact"
      | "st_point"
      | "st_distance"
      | "string_to_array"
      | "array_sum"
      | "object_agg"
      | "cast_to_str_type"
      | "check_json"
      | "check_xml"
      | "translate_characters"
      | "current_schemas"
      | "current_datetime"
      | "localtime"
      | "localtimestamp"
      | "systimestamp"
      | "current_schema"
      | "current_user"
      | "utc_time"
      | "utc_timestamp"
      | "date_bin"
      | "datetime_add"
      | "datetime_sub"
      | "datetime_diff"
      | "datetime_trunc"
      | "dayname"
      | "make_interval"
      | "previous_day"
      | "elt"
      | "timestamp_add"
      | "timestamp_sub"
      | "timestamp_diff"
      | "time_slice"
      | "time_add"
      | "time_sub"
      | "time_diff"
      | "time_trunc"
      | "date_from_parts"
      | "time_from_parts"
      | "decode_case"
      | "decrypt"
      | "decrypt_raw"
      | "encode"
      | "encrypt"
      | "encrypt_raw"
      | "equal_null"
      | "to_binary"
      | "base64_decode_binary"
      | "base64_decode_string"
      | "base64_encode"
      | "try_base64_decode_binary"
      | "try_base64_decode_string"
      | "gap_fill"
      | "generate_date_array"
      | "generate_timestamp_array"
      | "get_extract"
      | "getbit"
      | "overflow_truncate_behavior"
      | "hex_encode"
      | "compress"
      | "decompress_binary"
      | "decompress_string"
      | "xor"
      | "nullif"
      | "j_s_o_n"
      | "j_s_o_n_path"
      | "j_s_o_n_path_filter"
      | "j_s_o_n_path_key"
      | "j_s_o_n_path_recursive"
      | "j_s_o_n_path_script"
      | "j_s_o_n_path_slice"
      | "j_s_o_n_path_selector"
      | "j_s_o_n_path_subscript"
      | "j_s_o_n_path_union"
      | "format"
      | "j_s_o_n_keys"
      | "j_s_o_n_key_value"
      | "j_s_o_n_keys_at_depth"
      | "j_s_o_n_object"
      | "j_s_o_n_object_agg"
      | "j_s_o_n_b_object_agg"
      | "j_s_o_n_array"
      | "j_s_o_n_array_agg"
      | "j_s_o_n_exists"
      | "j_s_o_n_column_def"
      | "j_s_o_n_schema"
      | "j_s_o_n_set"
      | "j_s_o_n_strip_nulls"
      | "j_s_o_n_value"
      | "j_s_o_n_value_array"
      | "j_s_o_n_remove"
      | "j_s_o_n_table"
      | "j_s_o_n_type"
      | "object_insert"
      | "open_j_s_o_n_column_def"
      | "open_j_s_o_n"
      | "j_s_o_n_b_exists"
      | "j_s_o_n_b_contains"
      | "j_s_o_n_b_extract"
      | "j_s_o_n_cast"
      | "j_s_o_n_extract"
      | "j_s_o_n_extract_quote"
      | "j_s_o_n_extract_array"
      | "j_s_o_n_extract_scalar"
      | "j_s_o_n_b_extract_scalar"
      | "j_s_o_n_format"
      | "j_s_o_n_bool"
      | "j_s_o_n_path_root"
      | "j_s_o_n_array_append"
      | "j_s_o_n_array_contains"
      | "j_s_o_n_array_insert"
      | "parse_j_s_o_n"
      | "parse_url"
      | "parse_ip"
      | "parse_time"
      | "parse_datetime"
      | "map_cat"
      | "map_delete"
      | "map_insert"
      | "map_pick"
      | "scope_resolution"
      | "slice"
      | "var_map"
      | "match_against"
      | "m_d5_digest"
      | "m_d5_number_lower64"
      | "m_d5_number_upper64"
      | "monthname"
      | "ntile"
      | "normalize"
      | "normal"
      | "predict"
      | "m_l_translate"
      | "features_at_time"
      | "generate_embedding"
      | "m_l_forecast"
      | "model_attribute"
      | "vector_search"
      | "quantile"
      | "approx_quantile"
      | "approx_percentile_estimate"
      | "randn"
      | "randstr"
      | "range_n"
      | "range_bucket"
      | "read_c_s_v"
      | "read_parquet"
      | "reduce"
      | "regexp_extract_all"
      | "regexp_i_like"
      | "regexp_full_match"
      | "regexp_instr"
      | "regexp_split"
      | "regexp_count"
      | "regr_valx"
      | "regr_valy"
      | "regr_avgy"
      | "regr_avgx"
      | "regr_count"
      | "regr_intercept"
      | "regr_r2"
      | "regr_sxx"
      | "regr_sxy"
      | "regr_syy"
      | "regr_slope"
      | "safe_add"
      | "safe_divide"
      | "safe_multiply"
      | "safe_subtract"
      | "s_h_a2"
      | "s_h_a2_digest"
      | "sort_array"
      | "split_part"
      | "substring_index"
      | "standard_hash"
      | "str_position"
      | "search"
      | "search_ip"
      | "str_to_date"
      | "date_str_to_date"
      | "date_to_date_str"
      | "str_to_time"
      | "str_to_unix"
      | "str_to_map"
      | "number_to_str"
      | "from_base"
      | "stuff"
      | "time_to_str"
      | "time_str_to_time"
      | "ts_or_ds_add"
      | "ts_or_ds_diff"
      | "ts_or_ds_to_date"
      | "ts_or_ds_to_time"
      | "unhex"
      | "uniform"
      | "unix_to_str"
      | "unix_to_time"
      | "timestamp_from_parts"
      | "timestamp_tz_from_parts"
      | "corr"
      | "width_bucket"
      | "covar_samp"
      | "covar_pop"
      | "week"
      | "x_m_l_element"
      | "x_m_l_get"
      | "x_m_l_table"
      | "x_m_l_key_value_option"
      | "zipf"
      | "merge"
      | "when"
      | "whens"
      | "next_value_for"
      | "return_stmt"