knex: Support Typecasting Function Parameters (Postgis ST_Transform Bug)

I have come across a problem, with different solutions, but I would like to propose a feature that would allow the calling of functions to be typecasted in the parameterization.

First the code:

function ST_Transform(shape, srid)
    {
        let sridParam = '?';

        if (_.isNumber(srid))
        {
            sridParam += '::integer';
        }

        return knex.raw(`st_transform(?, ${sridParam})`, [shape, srid]);
    };

The Problem:

This is in a file called ‘postgis.js’ in my architecture. What it allows me to do is import postgis and call postgis.ST_Transform(geom, 4326). Originally this code was 1 line long that got wrapped up in a convenience function. That was until Postgis 2.3.0 dropped and they changed it so that ST_Transform now takes a string or an integer. This causes an error because parameterized raw statements do not get typecasted naturally.

The Solution:

If knex had a property that was .executeFunction() that:

• Took a string representation of a function name.
• An array of values to be passed in.
• An array of typecastings to be used.

It could be a very clean implementation for executing functions with correct types which has been requested multiple times from other issues. If we could start a discussion about a good way to accomplish this via code it would be appreciated and I would happily help with the implementation.