WASM UDF support

[snork-alt]

📝 Description:

This is a proposal for a new feature in Dozer Core, to enhance the functionality by allowing users to define a SQL User Defined Function (UDF) implemented in WASM (AssemblyScript)

🌟 Feature Details:

Users should be able to define a WASM UDF usable in Dozer SQL.

In order to implement an UDF a user should:

• Add a .wasm file to the project folder (for example in the directory udfs/wasm/my_function.wasm)
• Add the following configuration lines to dozer-config.yaml:

udfs:
  wasm:
     my_function: udfs/wasm/my_function

Upon startup Dozer should load the wasm function and make it available in Dozer SQL. my_function() should now be usable from SQL as:

SELECT my_function(filed1, field2) FROM ...

[snork-alt]

/bounty $600

[algora-pbc]

💎 $600 bounty • Dozer Data

Steps to solve:

1. Start working: Comment /attempt #1653 with your implementation plan
2. Submit work: Create a pull request including /claim #1653 in the PR body to claim the bounty
3. Receive payment: 100% of the bounty is received 2-5 days post-reward. Make sure you are eligible for payouts

Additional opportunities:

• 🔴 Livestream on Algora TV while solving this bounty & earn $200 upon merge! Make sure to have your camera and microphone on. Comment /livestream once live

Thank you for contributing to getdozer/dozer!

Add a bounty • Share on socials

Attempt	Started (GMT+0)	Solution
🟢 @hi-rustin	Jun 19, 2023, 3:35:39 PM	WIP
🟢 @tachyonicbytes	Jun 19, 2023, 11:46:33 PM	#1654
🟢 @varshith257	May 19, 2024, 4:35:43 PM	WIP

[0xPoe]

/attempt #1653

I will give it a try.

[jemilu2]

@hi-rustin, use the attempt comment above to indicate you've started working on it.

[0xPoe]

/attempt #1653

[tachyonicbytes]

Hi! I also wanted to explore this issue

/attempt #1653

[algora-pbc]

Note: The user @hi-rustin is already attempting to complete issue #1653 and claim the bounty. If you attempt to complete the same issue, there is a chance that @hi-rustin will complete the issue first, and be awarded the bounty. We recommend discussing with @hi-rustin and potentially collaborating on the same solution versus creating an alternate solution.

[algora-pbc]

💡 @tachyonicbytes submitted a pull request that claims the bounty. You can visit your org dashboard to reward.

[0xPoe]

@tachyonicbytes Perhaps before contributing to the open source community you need to ask the original people if they have started work. Otherwise, it's going to be an endless race for speed :(

[varshith257]

/attempt #1653

Algora profile	Completed bounties	Tech	Active attempts	Options
@varshith257	1 bounty from 1 project	TypeScript, Go	#1659	Cancel attempt