{"id":73883,"title":"🔹Serra - Simplify SQL with one command","tagline":"SQL to PySpark Translator","body":"**tl;dr:** never deal with unintuitive 1000+ line SQL scripts again. [Serra](https://github.com/Serra-Technologies/serra) simplifies SQL into modular PySpark objects that are much faster to run, reuse, and debug. Check out our repo [here](https://github.com/Serra-Technologies/serra)!\n\nHey everyone! We’re back again to announce the open-source launch of Serra—never deal with unintuitive 1000+ line SQL scripts again.\n\nWe’re also launching the beta of our translate feature with a free week trial! Get an easy starting point/suggestion for simplifying your SQL scripts into PySpark objects by running _serra translate your_script.sql_.\n\n![uploaded image](/media/?type=post\u0026id=73883\u0026key=user_uploads/1241137/65845ad3-4950-4357-a32b-dcd33981816f)\n\n### **❌ Problem:**\n\nSQL scripts are huge, messy, and hard to debug. Declarative, monolithic SQL gets overwhelming quickly for data analysts, scientists, and engineers—leading to huge time sinks and data outages.\n\n### **😌 How do we solve it?**\n\nWe’re a low-code ETL framework that simplifies SQL into modular PySpark objects that are much faster to run, reuse, and debug. Think end-to-end dbt with the benefits of object-oriented Spark!\n\nWe wrap all of this into a command-line tool that allows you to create your own PySpark jobs, run them locally, and simplify your SQL scripts to PySpark.\n\n### **👏 The Team**\n\n![uploaded image](/media/?type=post\u0026id=73883\u0026key=user_uploads/1241137/f1469834-d630-417d-942a-c9efec1a8e0d)\n\n[Alan](https://www.linkedin.com/in/alanhlwang/) and [Albert](https://www.linkedin.com/search/results/all/?fetchDeterministicClustersOnly=true\u0026heroEntityKey=urn%3Ali%3Afsd_profile%3AACoAABvJV34B9Kn2x938wSRljsdtR_Vu8-sNKUg\u0026keywords=albert%20stanley\u0026origin=RICH_QUERY_TYPEAHEAD_HISTORY\u0026position=0\u0026searchId=2590d498-3822-4c87-904c-47bec49bccd6\u0026sid=DN6) are best friends from middle school Algebra. Alan is an ex-Data Engineer at Disney+ and a Statistics \u0026 Data Science alum from UCLA. Albert is an ex-Software Engineer at Amazon Alexa and a UCLA Master’s graduate in Computer Science.\n\n### **Asks:**\n\n* Check out (and star 🤩) the repo: \u003chttps://github.com/Serra-Technologies/serra\u003e\n* Intros to any companies struggling with their SQL/data workflow—we’ll help retool their data workflow! Email us at [founders@serra.io](mailto:founders@serra.io).\n* Try it out yourself by doing a pip install of serra! For setup help feel free to reach out—make sure you have python \u003e= 3.10 installed!).","slug":"JDf-serra-simplify-sql-with-one-command","created_at":"2023-08-07T21:28:44.592Z","updated_at":"2026-05-13T09:57:19.629Z","total_vote_count":10,"url":"https://www.ycombinator.com/launches/JDf-serra-simplify-sql-with-one-command","share_image_url":"//bookface-static.ycombinator.com/assets/ycdc/yc-og-image-c440a0ad1dacfb86eeeb343717479cc54d256614449b4ef719977a0a451f8bc8.png","company":{"id":28863,"name":"Serra","slug":"serra","url":"https://www.serra.io/","logo":"https://bookface-images.s3.amazonaws.com/small_logos/de1a90717852abf9734482354e7229c962c19089.png","batch":"Summer 2023","industry":"B2B","tags":["Artificial Intelligence","Recruiting","HR Tech","Enterprise Software","AI Assistant"],"search_path":"https://bookface.ycombinator.com/company/28863"}}