Skip to main content
Archived

Using binding of named parameters in SqlExecutor/SqlCreator

Related products:Transformers
  • May 26, 2025
  • 3 replies
  • 41 views

nordpil
Supporter
Forum|alt.badge.img+11

Just for clarification - this is not about fme workspace parameters, rather about SQL named parameters.

Named parameters provides better security against SQL injection, improved query plan caching, ensures proper type handling among other things. Another advantage is that it makes it easier to just copy/paste the sql-code from a sql editor (like ADS, Dbeaver etc) where one would be provided with prompts to fill in the parameters.

It would be amazing if one just name a sql paramter the same as an attribute in the feature, and it would be picked up that way… !

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

PierreAtSafe
Safer
Forum|alt.badge.img+8
NewOpen

PierreAtSafe
Safer
Forum|alt.badge.img+8
Idea merged into:

All the votes from this idea have been transferred.

andreaatsafe
Safer
Forum|alt.badge.img+15
OpenArchived