Hi u/PaulieB79! This is Sam Green from Semiotic Labs. Thanks for the question!

Here are some milestones I would like to see Semiotic achieve in the coming year:

• Deploy Scalar TAP (The Graph’s new micropayment system). Once the hosted service subgraphs have been upgraded to The Graph Network, TAP will handle more micropayments than most other web2 and web3 systems.
• Deploy SQL for analytics queries in The Graph Network as a new data service. (See this thread for more details.)
• Deploy open-source large language models to The Graph Network as a new data service.
• Deploy verifiable Firehose.
• As a stretch goal this year, I would like Semiotic to deploy verifiable SQL queries. This would allow The Graph’s data to be used for high-consequence applications, like tax accounting.

Hi u/Drewsapple! This is Sam from Semiotic Labs. Regarding your rollout question, here’s the current status:
* We currently have Substreams to ClickHouse working well
* We have recently prototyped the SQL API
* We have a sketch for how to handle DBT experiments by the developer
* The plan is to get SQL queries on the network by Q1 2024
* We are very interested in learning more about our developers’ specific use cases for SQL. Please dm me if you would be interested in chatting!

Pinax will answer your OP stack question :)