As an aside I see Valentina reports now has embedded scripting with JavaScript, can JS request data from the database and is it possible to use a JSON object as the datasource for a report?

let res = [];



let tables_curs = datasource.sqlSelect("select tbl_name from sqlite_schema WHERE type = 'table' AND substr( name, 0, 8 ) <> 'sqlite_'");



if( tables_curs.firstRecord() )

{

	do

	{

		const tableName = tables_curs.columnValue(0);

		let fks_curs = datasource.sqlSelect( `PRAGMA FOREIGN_KEY_LIST('${ tableName }');` );

		

		if( fks_curs.firstRecord() )

		{

			do

			{

				const keyColumns = fks_curs.columnValue( 3 ).split(',').map((column) => column.trim()).join( ", " );

				const referencedColumns = fks_curs.columnValue( 4 ).split(',').map((column) => column.trim()).join( ", " );

				const referencedTable = fks_curs.columnValue( 2 );



				const foreignKeyObject = {

					  "constraintName": nulll,

					  "tableName": tableName,

					  "referencedTable": referencedTable,

					  "keyColumns": keyColumns,

					  "referencedColumns": referencedColumns,

					  "onUpdateAction": fks_curs.columnValue( 5 ),

					  "onDeleteAction": fks_curs.columnValue( 6 ),

					  "match": fks_curs.columnValue( 7 )

					};



				res.push( foreignKeyObject );

			}

			while( fks_curs.nextRecord() )

		}

	}

	while( tables_curs.nextRecord() )

}

	

res