Supports filter string using regular expression matching

[chai3]

Describe the feature or potential improvement

regex is powerful

Additional information

Probably add 3 lines

langfuse/packages/shared/src/interfaces/filters.ts

Line 5 in bb6bc79

string: ["=", "contains", "does not contain", "starts with", "ends with"],

langfuse/packages/shared/src/interfaces/filters.ts

Lines 9 to 15 in bb6bc79

	stringObject: [
	"=",
	"contains",
	"does not contain",
	"starts with",
	"ends with",
	],

add "regex with"

langfuse/packages/shared/src/filterToPrisma.ts

Lines 6 to 13 in bb6bc79

	const operatorReplacements = {
	"any of": "IN",
	"none of": "NOT IN",
	contains: "ILIKE",
	"does not contain": "NOT ILIKE",
	"starts with": "ILIKE",
	"ends with": "ILIKE",
	};

add "regex with": "~*" // case-insensitively
or "~" // case sensitively

We can add "does not regex with": "!~*" or !~

see also https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-POSIX-REGEXP

[marcklingen]

thanks for sharing, great idea! are you interested in contributing this?

[chai3]

@marcklingen YES

[chai3]

@marcklingen I created #3055