Index

_

__parse_query() (QueryProfiler method) __single_obj_dict_to_tuple() (QueryProfiler method) _construct_edges() (SchemaGraph method) _construct_graph() (SchemaGraph method)

_construct_orphan_table_list() (SchemaGraph method) _construct_pkfk_dataframe() (SchemaGraph method) _construct_vertice_lookup_dicts() (SchemaGraph method) _mp_batch_function() (word_list_matching.NaturalnessCalculator method) _repair_constraints() (SchemaGraph method)

A

all_tests() built-in function

assign_label_from_score() (word_list_matching.NaturalnessCalculator method)

B

build_natural_view_queries() (NaturalViewBuilder method) built-in function all_tests() call_code_llama() call_codey() call_google_palm() call_gpt() call_togetherai() call_vertex() classify_batch_with_canine() classify_db_schema() clean() compare_gold_to_generated() compare_queries() compare_query_schema_elements() denaturalize_query() denaturalize_query_test() do_batch_compare() do_single_question() do_single_question_test() evaluate_queries_in_workbook() export_gold_data() get_decoded_token_list() load_nlq_into_df() log_attempt() main() make_token_tag() mp_compare_query_schema_elements() mp_query_parse_function() mp_schema_linking_eval() naturalize_prompt() nl_to_sql_generation() print_tagged_query() profile_query_test() record_evaluation() separate_by_line() tag_query_test() update_scores_in_existing_results()

C

calculate_score_and_distance_of_delim_and_composite() (word_list_matching.NaturalnessCalculator method) call_code_llama() built-in function call_codey() built-in function call_google_palm() built-in function call_gpt() built-in function call_togetherai() built-in function call_vertex() built-in function CanineIdentifierClassifier (built-in class) classify_batch_with_canine() built-in function classify_db_schema() built-in function

classify_identifier() (CanineIdentifierClassifier method) clean() built-in function codellama.json (built-in variable) compare_gold_to_generated() built-in function compare_letter_order() (word_list_matching.NaturalnessCalculator method) compare_queries() built-in function compare_query_schema_elements() built-in function config_dict (ConsolidatedResultsLoader attribute) connect_to_db() (in module db_util) (in module db_util_sqlite) ConsolidatedResultsLoader (built-in class) create_views_in_database() (NaturalViewBuilder method) create_word_letter_freq_vectors() (word_list_matching.NaturalnessCalculator method) CsvDataDictInterpreter (built-in class)

D

DataDictInterpreter (built-in class) DataDictInterpreterFactory (built-in class) db_util module db_util_sqlite module debug_print() (in module word_list_matching) default_value() (word_list_matching.NaturalnessCalculator method) default_value_list() (word_list_matching.NaturalnessCalculator method) denaturalize_query() built-in function denaturalize_query_test() built-in function

DfVariable (built-in class) distance_batch_function() (word_list_matching.NaturalnessCalculator method) do_batch_compare() built-in function do_batch_job() (CanineIdentifierClassifier method) do_query() (in module db_util) (in module db_util_sqlite) do_schema_renaming() (in module schemarenamer) do_single_question() built-in function do_single_question_test() built-in function

E

evaluate_naturalness() (word_list_matching.NaturalnessCalculator method) evaluate_queries_in_workbook() built-in function

export_gold_data() built-in function

F

find_most_natural_in_composite() (word_list_matching.NaturalnessCalculator method)

G

get() (DfVariable method) get_best_match() (word_list_matching.NaturalnessCalculator method) get_connecting_vertices_and_edges() (SchemaGraph method) get_context_around_identifier() (CsvDataDictInterpreter method) (DataDictInterpreter method) (JsonDataDictInterpreter method) (PdfDataDictInterpreter method) (XmlDataDictInterpreter method) get_current_interpreter() (DataDictInterpreterFactory method) get_db_tables_cardinality() (in module db_util) get_decoded_token_list() built-in function get_identifiers_and_labels() (QueryProfiler method) get_identifiers_and_labels_df() (QueryProfiler method)

get_joined_dataframes() (ConsolidatedResultsLoader method) get_levenshstein_dist_dict() (word_list_matching.NaturalnessCalculator method) get_min_distance_for_single_word() (word_list_matching.NaturalnessCalculator method) get_new_interpreter() (DataDictInterpreterFactory method) get_schema_identifiers_between_tables() (SchemaGraph method) get_table_cardinality() (in module db_util) get_table_connections() (SchemaGraph method) get_tables_and_columns_df() (in module db_util) (in module db_util_sqlite) get_tables_and_columns_from_sql_server_db() (in module db_util) get_tables_and_columns_from_sqlite_db() (in module db_util_sqlite) get_words_with_letters_in_order() (word_list_matching.NaturalnessCalculator method) get_words_with_same_letters() (word_list_matching.NaturalnessCalculator method) getNaturalIdentifier() (DataDictInterpreter method)

I

index_dictionary_file() (CsvDataDictInterpreter method) (DataDictInterpreter method) (JsonDataDictInterpreter method) (PdfDataDictInterpreter method) (XmlDataDictInterpreter method)

initialize_db_nl_schema() (NaturalViewBuilder method) interactive_prompt_builder() (DataDictInterpreter method) iterate_possible_words() (word_list_matching.NaturalnessCalculator method)

J

JsonDataDictInterpreter (built-in class)

L

load_annotation_files() (ConsolidatedResultsLoader method) load_identifier_crosswalks() (ConsolidatedResultsLoader method) load_identifier_token_analysis_files() (ConsolidatedResultsLoader method) load_nlq_into_df() built-in function load_prompt_tokens() (ConsolidatedResultsLoader method)

load_query_token_character_ratio_file() (ConsolidatedResultsLoader method) load_question_token_analysis_files() (ConsolidatedResultsLoader method) load_sentence_level_similarities() (ConsolidatedResultsLoader method) load_world_level_similarities() (ConsolidatedResultsLoader method) log_attempt() built-in function

M

main() built-in function main() (in module schemarenamer) (in module word_list_matching) make_db_schema_prompt() (in module db_util) (in module db_util_sqlite) make_few_shot_prompt() (DataDictInterpreter method) make_token_tag() built-in function make_zero_shot_prompt() (DataDictInterpreter method) module db_util db_util_sqlite schemarenamer word_list_matching

mp_calculate_score_and_distance_of_delim_and_composite() (word_list_matching.NaturalnessCalculator method) mp_compare_query_schema_elements() built-in function mp_get_min_distance_for_word_list() (word_list_matching.NaturalnessCalculator method) mp_query_parse_function() built-in function mp_schema_linking_eval() built-in function

N

naturalize_prompt() built-in function NaturalnessCalculator (class in word_list_matching)

NaturalViewBuilder (built-in class) nl_to_sql_generation() built-in function

P

parse_tree_pretty_print() (QueryProfiler method) PdfDataDictInterpreter (built-in class) populate_db_nl_tables() (NaturalViewBuilder method) print_tagged_query() built-in function

profile_query() (QueryProfiler method) profile_query_test() built-in function

Q

QueryProfiler (built-in class)

R

record_evaluation() built-in function

S

SchemaGraph (built-in class) schemarenamer module

score_result() (word_list_matching.NaturalnessCalculator method) separate_by_line() built-in function set() (DfVariable method)

T

tag_query() (QueryProfiler method) tag_query_test() built-in function

tokenize_identifier() (word_list_matching.NaturalnessCalculator method) transform_score_df() (in module schemarenamer)

U

update_scores_in_existing_results() built-in function

W

word_list_matching module

X

XmlDataDictInterpreter (built-in class)