This function is heavily inspired by the unexported dbplyr function unique_table_name
Examples
print(unique_table_name()) # SCDB_<10 alphanumerical letters>
#> SCDB_HcXq3OSn2e
print(unique_table_name()) # SCDB_<10 alphanumerical letters>
#> SCDB_Xl258RgjzX
print(unique_table_name("test")) # test_<10 alphanumerical letters>
#> test_6JVzH3QNth
print(unique_table_name("test")) # test_<10 alphanumerical letters>
#> test_ByrdeDhSCD