如何使用es6语法有效地过滤像嵌套Sql查询这样的JSON数组对象

const data = [
  { id: 1, name: 'John', age: 25 },
  { id: 2, name: 'Jane', age: 30 },
  { id: 3, name: 'Bob', age: 20 },
  { id: 4, name: 'Alice', age: 35 }
];

const filteredData = data.filter(item => item.age > 25);
console.log(filteredData);

const data = [
  { id: 1, name: 'John', age: 25 },
  { id: 2, name: 'Jane', age: 30 },
  { id: 3, name: 'Bob', age: 20 },
  { id: 4, name: 'Alice', age: 35 }
];

const filteredData = data.reduce((acc, item) => {
  if (item.age > 25) {
    acc.push(item);
  }
  return acc;
}, []);

console.log(filteredData);

const data = [
  { id: 1, name: 'John', orders: [{ id: 1, product: 'A' }, { id: 2, product: 'B' }] },
  { id: 2, name: 'Jane', orders: [{ id: 3, product: 'C' }, { id: 4, product: 'D' }] },
  { id: 3, name: 'Bob', orders: [{ id: 5, product: 'E' }, { id: 6, product: 'F' }] },
  { id: 4, name: 'Alice', orders: [{ id: 7, product: 'G' }, { id: 8, product: 'H' }] }
];

const filteredData = data.flatMap(item => item.orders.filter(order => order.product === 'A'));
console.log(filteredData);