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