How to create a query (not data view) that return transcluded files?

I would like to embed in a document all files in a certain folder. I need them to be transcluded (i.e. their content inserted in the file), not just listed as a series of links.

Things I have tried

I have tried with Dataview, but I don’t want to rely on a third party plugin. I have searched how to use embedded queries, but the answers (which all said ‘no, it’s not possible with a standard query’) are several years old. I wonder if there’s something newer that can be used?

This is still impossible with standard query. You can to write smth like `ls /path/to/certain/folder | sed -r ‘s/.*/![[path/to/certain/folder/in/vault/\0]]/’ > /path/to/your/note/with/embebed/files` in your OS command line and you’ll see static note with only content of files in that folder. My example should work in linux, for other OS ask AI how to translate command. Although you can write static note with necessary embeds by hands with known and comfortable for you way.

Or you can use dvjs-script (this is Dataview feature), smth like this:

// Path to the folder (relative to the vault root)
let folderPath = "path/to/folder";

// Retrieve all files from the folder via the Vault API
let files = app.vault.getMarkdownFiles()
    .filter(f => f.path.startsWith(folderPath));

// Iterate through each file
for (let file of files) {
    // Header with a link
    dv.header(3, dv.fileLink(file.path));
    
    // Read the file content
    let content = await app.vault.read(file);
    
    // Output the content (can be truncated if necessary)
    dv.paragraph(content);
    
    // Separator
    dv.paragraph("---");
}