ID_NAME_QUERY

ID_NAME_QUERY = 'SELECT\n    MOLECULE_DICTIONARY.chembl_id,\n    MOLECULE_DICTIONARY.pref_name\nFROM MOLECULE_DICTIONARY\nJOIN COMPOUND_STRUCTURES ON MOLECULE_DICTIONARY.molregno == COMPOUND_STRUCTURES.molregno\nWHERE molecule_dictionary.pref_name IS NOT NULL\n'

This query yields tuples of ChEMBL identifiers and their preferred names, omitting pairs where there is no name or if there’s no structure