Text this: Unlocking the potential of flavonoid biosynthesis through integrated metabolic engineering