SQL query: Posts, Tag, E DATA

Sql server test

SELECT *
FROM DBHive.dbo.TxComments
WHERE parent_permlink = 'sql-ptbr' AND parent_author = '' AND [timestamp] >= Convert(datetime, '2020-11-27' ) ;

Como pegar somente posts recentes usando o hivesql:

SELECT author, permlink, title, created, body_language FROM DBHive.dbo.Comments WHERE parent_author = '' AND created >= Convert(datetime, '2021-06-02' );

Baixe em csv e converta pra json usando o https://csvjson.com/csv2json

Abrindo o Json usando o nodejs e filtrar o idioma somente em portugues:

const fs = require('fs');
let rawdata = fs.readFileSync('csvjson.json');
let datatop = JSON.parse(rawdata);

var data = [{}]

for (const index in datatop) {   
    if(datatop[index]['body_language'][0]){
        if(datatop[index]['body_language'][0]['language'] === 'pt'){
            if(datatop[index]['body_language'][0]['confidence'] > 5.0){
                console.log(datatop[index]['body_language'][0]['language'] + ' ' + index ) 
                data.push(datatop[index])
            }
        }
        else if(datatop[index]['body_language'][1]){ 
            if(datatop[index]['body_language'][1]['language'] === 'pt'){
                    if(datatop[index]['body_language'][1]['confidence'] > 5.0){
                        console.log(datatop[index]['body_language'][1]['language'] + ' ' + index ) 
                        data.push(datatop[index])
                    }
                }
        }
        else if(datatop[index]['body_language'][2]){ 
            if(datatop[index]['body_language'][2]['language'] === 'pt'){
                    if(datatop[index]['body_language'][2]['confidence'] > 5.0){
                    console.log(datatop[index]['body_language'][2]['language'] + ' ' + index ) 
                    data.push(datatop[index])
                    }
                }
        }
    }
    else{}
}

var newData1 = JSON.stringify(data);
fs.writeFile('csvjson1.json', newData1, err => {
    if(err) throw err;
    
    console.log("New data added");
});