This function is heavily inspired by the unexported dbplyr function unique_table_name
Examples
print(unique_table_name()) # SCDB_<10 alphanumerical letters>
#> SCDB_n2eXl258Rg
print(unique_table_name()) # SCDB_<10 alphanumerical letters>
#> SCDB_jzX6JVzH3Q
print(unique_table_name("test")) # test_<10 alphanumerical letters>
#> test_NthByrdeDh
print(unique_table_name("test")) # test_<10 alphanumerical letters>
#> test_SCD0ClxZl1