system.database_engines

SELECT *
FROM system.database_engines
WHERE name IN ('Atomic', 'Lazy', 'Ordinary')

┌─name─────┐
│ Ordinary │
│ Atomic   │
│ Lazy     │
└──────────┘