Searches are case sensetive

[structwafel]

Describe the bug

currently searches are done in a case-sensitive way, which i do not thing is intended.

	q := '%' + query + '%'
	pkgs := sql p.db {
		select from Package where name like q
	} or { [] }

Expected Behavior

Query like: emma should display EmmaTheMartian.vnoise

Current Behavior

emma does not display EmmaTheMartian.vnoise

only Emma does

Reproduction Steps

https://vpm.vlang.io/search?q=Emma

https://vpm.vlang.io/search?q=emma

Possible Solution

the ability to use ilike or lower functions in the orm.

Don't yet understand the workings of the vlib/db / orm, but might need to add new functionality there to support these functions/ new operators

Additional Information/Context

No response

V version

0.4.5

Environment details (OS name and version, etc.)

V full version: V 0.4.5 927cc01.c0fec31
OS: linux, "Arch Linux"
Processor: 16 cpus, 64bit, little endian, AMD Ryzen 7 5800X 8-Core Processor

getwd: /home/lgx/git
vexe: /home/lgx/git/v/v
vexe mtime: 2024-05-08 12:49:01

vroot: OK, value: /home/lgx/git/v
VMODULES: OK, value: /home/lgx/.vmodules
VTMP: OK, value: /tmp/v_1000

Git version: git version 2.45.0
Git vroot status: weekly.2024.19-24-gc0fec31b-dirty
.git/config present: true

CC version: cc (GCC) 13.2.1 20240417
thirdparty/tcc status: thirdparty-linux-amd64 40e5cbb5