How can I use tsx to run a "bin" root file

[jraoult]

I'm trying to migrate from ts-node to tsx in an existing project, but I'm struggling with one particular case. We use a library to run SQL migration scripts and here's how they recommend running with ts-node:

ts-node node_modules/.bin/node-pg-migrate -j ts

(cf. https://salsita.github.io/node-pg-migrate/#/transpiling?id=use-global-configuration-1)

I tried running tsx node_modules/.bin/node-pg-migrate -j ts but I get:

TypeError [ERR_UNKNOWN_FILE_EXTENSION]: Unknown file extension "" for [..]/node_modules/node-pg-migrate/bin/node-pg-migrate

Is there a way around this limitation?