Functional Indexes
So working with PlanetScale and have a query that checks for LOWER(city) and LOWER(state) to handle user input. How can I use Drizzle-orm to create the composite functional index. I've tried a bunch of variations like the below but no luck.
stateCityIdx: index("state_city_idx").on(
sql
),
stateCityIdx: index("state_city_idx").on(
sql
(LOWER(${table.city}) LOWER(${table.state}))),
