Support Reuse of Custom Raw Expressions about jet HOT 4 CLOSED

If you want to reuse your custom function or operators, they'll have to accept Expression as a input parameter.

func WordSimilarity(word1, word2 StringExpression) FloatExpression {
	return FloatExp(Func("word_similarity", word1, word2))
}

Note the use of Func - https://github.com/go-jet/jet/wiki/FAQ#how-to-call-custom-or-currently-unsupported-sql-function

Now you can call this function as:

WordSimilarity(String("John"), Actor.LastName)
WordSimilarity(String("James"), LTRIM(Actor.FirstName, String("A")))
etc...

For CosineDistance operator you can use the new CustomExpression function - #355 (comment)
This method is merged to the master branch but is not yet part of the latest release.

func CosineDistance(vector1, vector2 Expression) FloatExpression {
	return FloatExp(CustomExpression(vector1, Token("<=>"), vector2))
}

Since pgvector is currently unsupported, you'll have to add it yourself:

func PgVector(array ...string) Expression {
	return Raw("#1", RawArgs{"#1": <your pgvector type>})
}

Finally, you should be able to write:

CosineDistance(PgVector("john", "doe"), PgVector("mike", "jones", "jim", "nate"))
CosineDistance(PgVector("john"), Actor.PgVectorColumn)
etc...

from jet.

thanks for the suggestion @houten11! I should have clarified further in my example. I want to be able to be able to sum the two functions together without writing a new function altogether (going to use this in the select clause) e.g. CosineDistance() + WordSimilarity()

my current workaround is not wrapping the raw queries into the expression types and then wrapping it after appending them together

from jet.

Both functions returns FloatExpression, meaning you can write:

WordSimilarity(String("John"), Actor.LastName).ADD(
    CosineDistance(PgVector("john", "doe"), PgVector("mike", "jones", "jim", "nate")))

from jet.

ahhh I totally goofed on that. Just need to use the FloatExpression instead of the generic Expression. thanks!

from jet.