str.upper

print("\n" + "="*80)
        print("POPULAR TOPICS ANALYSIS RESULTS")
        print("="*80)

        for analysis in analyses:
            print(f"\nTOPIC: {analysis.topic.upper()}")
            print("-" * 60)

            for size in self.sizes:
                print(f"\n  {size.upper()} Projects:")

                for language in self.languages:
                    projects = analysis.projects[size][language]
                    if projects:
                        print(f"\n    {language}:")
                        for i, project in enumerate(projects, 1):
                            print(f"      {i}. {project.name}")
                            print(f"         {project.stars:,} stars")
                            print(f"         {project.size_mb:.1f} MB")
                            print(f"         {project.url}")
                            if project.description:
                                print(f"         {project.description[:80]}...")

    def save_results_json(self, analyses: List[TopicAnalysis], output_path: str = "topics_analysis.json"):
        """Save analysis results to JSON file in flat format: Topic + size + language + github repo name."""

# Execute the query
        cursor.execute(request.query)

        # Handle different query types
        if request.query.strip().upper().startswith(("SELECT", "PRAGMA", "EXPLAIN")):
            # For SELECT queries, return the results
            rows = cursor.fetchall()

            # Extract column names
            columns = [column[0] for column in cursor.description]

            # Convert rows to dictionaries
            result_rows = []
            for row in rows:
                result_rows.append({columns[i]: row[i] for i in range(len(columns))})

            result = {
                "columns": columns,
                "rows": result_rows
            }
        else:
            # For other queries (INSERT, UPDATE, DELETE), commit changes and return affected rows
            conn.commit()
            result = {