Table name in SQL select snap

I saw this write up from a Postgesql update snap, I wonder if this applies to all database type snaps ?

Do you mind putting a pipeline parameter and test it? If this can be allowed from the pipeline parameter then you can use an expression library and put the function there

sample of expression file content
{
‘getDynamicTableName’ : (table_prefix = “abc_”) => table_prefix.concat(Date.now().getFullYear().toString())
}

then set the expression file in the pipeline and invoke the method in the SQL select snap under table name

e.g lib.extender.getDynamicTableName()

The values can be passed using the pipeline parameters but not the upstream parameter