ilike function doesnt exist in astro:db

[renhiyama]

Astro Info

Astro                    v5.1.8
Node                     v22.7.0
System                   Linux (x64)
Package Manager          bun
Output                   server
Adapter                  @astrojs/netlify
Integrations             @astrojs/tailwind
                         @astrojs/react
                         astro:db
                         @astrojs/db/file-url

If this issue only occurs in one browser, which browser is a problem?

No response

Describe the Bug

The like function says ilike function exists.

Importing ilike function would show an error though.

We obviously cant mix and match drizzle-orm ilike functions and astro:db functions. It would show an error.

What's the expected result?

ilike function should exist in astro:db

Link to Minimal Reproducible Example

https://stackblitz.com/edit/github-v8h3degz?file=src%2Fpages%2Findex.astro

Participation

• I am willing to submit a pull request for this issue.

[ematipico]

Probably we don't expose that function from astro:db package. Feel free to send a PR for that. We just need to update this file and add a changeset

astro/packages/db/src/runtime/virtual.ts

Lines 54 to 85 in 4cb3377

	export {
	sql,
	eq,
	gt,
	gte,
	lt,
	lte,
	ne,
	isNull,
	isNotNull,
	inArray,
	notInArray,
	exists,
	notExists,
	between,
	notBetween,
	like,
	notIlike,
	not,
	asc,
	desc,
	and,
	or,
	count,
	countDistinct,
	avg,
	avgDistinct,
	sum,
	sumDistinct,
	max,
	min,
	} from 'drizzle-orm';