🐦 Twitter Post Details

Viewing enriched Twitter post

@jerryjliu0

Simple text-to-SQL is trivial, actual enterprise-grade text-to-SQL is hard. There should be a lot more tutorials like the one from @kiennt_ on creating a proper SQL agent. You need to first map out and index your entire data catalog, and figure out how to retrieve from it (advanced retrieval, graphRAG) in order to properly inform SQL generation. Check out the blog below: https://t.co/kIAa7iIq0x

Media 1

πŸ“Š Media Metadata

{
  "score": 0.76,
  "scored_at": "2025-08-09T13:46:07.550266",
  "import_source": "network_archive_import",
  "links_checked": true,
  "checked_at": "2025-08-10T10:32:43.855411",
  "media": [
    {
      "type": "photo",
      "url": "https://crmoxkoizveukayfjuyo.supabase.co/storage/v1/object/public/media/posts/1850655329333522487/media_0.jpg?",
      "filename": "media_0.jpg"
    },
    {
      "id": "",
      "type": "photo",
      "url": null,
      "media_url": "https://pbs.twimg.com/media/Ga7ZNpnaoAAdlbp.jpg",
      "media_url_https": null,
      "display_url": null,
      "expanded_url": null
    }
  ],
  "reprocessed_at": "2025-08-12T15:25:25.648518",
  "reprocessed_reason": "missing_media_array",
  "original_structure": "had_both"
}

πŸ”§ Raw API Response

{
  "user": {
    "created_at": "2011-09-07T22:54:31.000Z",
    "default_profile_image": false,
    "description": "co-founder/CEO @llama_index\n\nCareers: https://t.co/EUnMNmbCtx\nEnterprise: https://t.co/Ht5jwxSrQB",
    "fast_followers_count": 0,
    "favourites_count": 7173,
    "followers_count": 54387,
    "friends_count": 1364,
    "has_custom_timelines": true,
    "is_translator": false,
    "listed_count": 1136,
    "location": "",
    "media_count": 1063,
    "name": "Jerry Liu",
    "normal_followers_count": 54387,
    "possibly_sensitive": false,
    "profile_image_url_https": "https://pbs.twimg.com/profile_images/1283610285031460864/1Q4zYhtb_normal.jpg",
    "screen_name": "jerryjliu0",
    "statuses_count": 5321,
    "translator_type": "none",
    "url": "https://t.co/YiIfjVlzb6",
    "verified": true,
    "withheld_in_countries": [],
    "id_str": "369777416"
  },
  "id": "1850655329333522487",
  "conversation_id": "1850655329333522487",
  "full_text": "Simple text-to-SQL is trivial, actual enterprise-grade text-to-SQL is hard.\n\nThere should be a lot more tutorials like the one from @kiennt_ on creating a proper SQL agent. You need to first map out and index your entire data catalog, and figure out how to retrieve from it (advanced retrieval, graphRAG) in order to properly inform SQL generation.\n\nCheck out the blog below: https://t.co/kIAa7iIq0x",
  "reply_count": 5,
  "retweet_count": 69,
  "favorite_count": 348,
  "hashtags": [],
  "symbols": [],
  "user_mentions": [
    {
      "id_str": "1578958663",
      "name": "Ryan Nguyen",
      "screen_name": "kiennt_",
      "profile": "https://twitter.com/kiennt_"
    }
  ],
  "urls": [],
  "media": [
    {
      "media_url": "https://pbs.twimg.com/media/Ga7ZNpnaoAAdlbp.jpg",
      "type": "photo"
    }
  ],
  "url": "https://twitter.com/jerryjliu0/status/1850655329333522487",
  "created_at": "2024-10-27T21:46:28.000Z",
  "#sort_index": "1850655329333522487",
  "view_count": 39984,
  "quote_count": 6,
  "is_quote_tweet": true,
  "is_retweet": false,
  "is_pinned": false,
  "is_truncated": true,
  "quoted_tweet": {
    "user": {
      "created_at": "2022-12-18T00:52:44.000Z",
      "default_profile_image": false,
      "description": "Build LLM agents over your data\n\nGithub: https://t.co/HC19j7vMwc\nDocs: https://t.co/QInqg2zksh\nDiscord: https://t.co/3ktq3zzYII",
      "fast_followers_count": 0,
      "favourites_count": 1261,
      "followers_count": 82611,
      "friends_count": 26,
      "has_custom_timelines": false,
      "is_translator": false,
      "listed_count": 1366,
      "location": "",
      "media_count": 1375,
      "name": "LlamaIndex πŸ¦™",
      "normal_followers_count": 82611,
      "possibly_sensitive": false,
      "profile_banner_url": "https://pbs.twimg.com/profile_banners/1604278358296055808/1696908553",
      "profile_image_url_https": "https://pbs.twimg.com/profile_images/1623505166996742144/n-PNQGgd_normal.jpg",
      "screen_name": "llama_index",
      "statuses_count": 2997,
      "translator_type": "none",
      "url": "https://t.co/epzefqQqZx",
      "verified": true,
      "withheld_in_countries": [],
      "id_str": "1604278358296055808"
    },
    "id": "1850340995482952190",
    "conversation_id": "1850340995482952190",
    "full_text": "Reliable Text-to-SQL over 500 Tables πŸ”₯πŸ”Ž\n\nMost text-to-SQL tutorials are easy and operate over β€œtrivial” examples like 2-3 tables. This tutorial by @kiennt_ is one of the best we’ve seen in showing you how to construct a SQL agent that can operate over a large and complex data model (500+ tables, relationships between them).\n\nHere are some of the key steps:\n1. Iterate through each table and extract a structured schema with LLM-generated summaries\n2. Use hierarchical chunking and indexing to help retrieve an initial set of relevant tables\n3. Use graphRAG techniques to provide tables related to the existing tables\n4. Feed relevant and related set of tables to text-to-SQL prompt to generate the query\n\nhttps://t.co/pSYc3NWa38",
    "reply_count": 7,
    "retweet_count": 117,
    "favorite_count": 498,
    "hashtags": [],
    "symbols": [],
    "user_mentions": [
      {
        "id_str": "1578958663",
        "name": "Ryan Nguyen",
        "screen_name": "kiennt_",
        "profile": "https://twitter.com/kiennt_"
      }
    ],
    "urls": [],
    "media": [
      {
        "media_url": "https://pbs.twimg.com/media/Ga27U0ma4AA-rmi.jpg",
        "type": "photo"
      }
    ],
    "url": "https://twitter.com/llama_index/status/1850340995482952190",
    "created_at": "2024-10-27T00:57:25.000Z",
    "#sort_index": "1850655329333522400",
    "view_count": 73362,
    "quote_count": 5,
    "is_quote_tweet": false,
    "is_retweet": false,
    "is_pinned": false,
    "is_truncated": true
  },
  "startUrl": "https://x.com/jerryjliu0/status/1850655329333522487"
}