SqlKata generating query with unfulfilled parameters about querybuilder HOT 4 CLOSED

thanks for your suggestion, but including the values directly in the generated sql open the door for unsecure/un-efficient code, this is why I am against this approach

from querybuilder.

I just saw, that the RawSql parameter contains

INSERT INTO `s_categories_avoid_customergroups` (`categoryID`, `customergroupID`) VALUES (?, ?)

though I'm still confused as to why, since I'm passing the dictionary, expecting the wildcards to be replaced with the actual values I set.

from querybuilder.

This what is called parameters bindings, which is recommended to execute queries, for debugging purposes you can use the compiler.Compile(query).ToString()

Check https://stackoverflow.com/a/4712113/1104402 for more info

from querybuilder.

Well, I know parameterized queries, though I'm confused as to why the values aren't included in the query by the get-go.

Maybe as a feature request, you could have a parameter, which has the values in the query right away, properly escaped (maybe like SqlFull), so you aren't forced to use parameterized queries.

from querybuilder.