Domain by Name
Fetch a Domain by its canonical name. Because canonical_name is materialized across both ENSv1 and ENSv2, the same lookup works regardless of protocol version. See Connect for setup.
SELECT * FROM ensindexer_0.domainsWHERE canonical_name = 'vitalik.eth';import { eq } from 'drizzle-orm';
const [vitalik] = await ensDb .select() .from(ensIndexerSchema.domain) .where(eq(ensIndexerSchema.domain.canonicalName, "vitalik.eth"));