Lowercased include_tables in SQLDatabase.from_uri

[huineng]

spent an hour to figure this out (great work by the way)

connection to db2 via alchemy

db = SQLDatabase.from_uri(
    db2_connection_string,
    schema='MYSCHEMA',
    include_tables=['MY_TABLE_NAME'], # including only one table for illustration
	sample_rows_in_table_info=3
)

this did not work .. until i lowercased it and then it worked

db = SQLDatabase.from_uri(
    db2_connection_string,
    schema='myschema',
    include_tables=['my_table_name], # including only one table for illustration
	sample_rows_in_table_info=3
)

tables (at least in db2) can be selected either uppercase or lowercase

by the way .. All fields are lowercased .. is this on purpose ?

thanks

[huineng]

i'm going to close this as it might be related to ibm_db_sa and alchemy
ibmdb/python-ibmdbsa#122