Support to load *.sql file

[karrybit]

Is it possible to load external SQL files just like JSON or YAML using something like sql://? This feature is helpful for us in the following cases when setting up test data.

• We want to avoid unique constraints in the DB using randomly generated values
• We want to use the generated tenant ID in SQL to operate on the same tenant in different steps

I would greatly appreciate your consideration.

[k1LoW]

Hi @karrybit

Is the point that you want to load the contents of the file as a string?

We want to avoid unique constraints in the DB using randomly generated values

Perhaps the built-in function faker.* might be useful.

[k2tzumi]

It may not be directly linked to this proposal, but I have considered supporting csvq before
#90

[k1LoW]

Support for file:// to read an arbitrary file as a string has been added in v0.130.1 👍
Also, file() has been added to the built-in functions.

[karrybit]

@k1LoW
Sorry for the late reply. Thank you for your help!