Likert Scale Randomization / API or parsing data from form to my database

Hi there. I'm trying to build a more complexed survey and I need to understand if Jotform can accommodate.

The survey consists of 3 sections.

1) General Information: This section will have questions that require free form text boxes. The free form text boxes must have character length limits. Can Jotform do this?

2) Section 2 and 3, are Likert Scale fields such as:

How important is teamwork to your employer?

-Extremely important, Very important -Moderately important -Slightly important -Not at all

These questions (not the answers) need to be randomized per new user to avoid common method bias. How can I do this?

Also, sections 2 and 3 cannot be grouped together. They must have their own randomization. Can this be done? If so how?

Can I ask a question like: Choose your top 20 values from a list, then once they choose the 20...ask them another question to narrow those 20 down to their top 10? (logic jumps...assumingly)

Lastly, I need to be able to export the data (via API or something) into my SQL database instantly through code. What is your solution for that? 

Please help! If you can help me, I will gladly signup for the service right now. 

1). Yes, you can indeed limit the number of characters entered in a field, to achieve that you only need to open the field properties, go to the options tab and turn on the limit entry option: 

2). You could use either a check box or survey fields to list these questions: 

These questions (not the answers) need to be randomized per new user to avoid common method bias. How can I do this?

This can be done using our Shuffle widget: http://widgets.jotform.com/widget/shuffle 

This guide will help to add the widget: https://www.jotform.com/help/252-How-to-Add-a-Widget-to-your-Form 

Also, sections 2 and 3 cannot be grouped together. They must have their own randomization. Can this be done? If so how?

You could add a page break to separate your fields, I have tested this and I can see the fields will be changed inside the page section, they will not be changed with fields of other pages. 

This guide will help you to add the page break to your form: https://www.jotform.com/help/119-How-to-Create-Multi-Page-Forms 

Can I ask a question like: Choose your top 20 values from a list, then once they choose the 20...ask them another question to narrow those 20 down to their top 10? (logic jumps...assumingly)

You could indeed list the options, but as far as I know it is not possible to send this selected options to another field and allow them to be ordered. 

However, you may take a look on these widgets that may help you: 

https://widgets.jotform.com/app/dual_listbox

https://widgets.jotform.com/app/visual_multi_select

https://widgets.jotform.com/widget/orderable_list

Lastly, I need to be able to export the data (via API or something) into my SQL database instantly through code.  What is your solution for that? 

You could get info about our API here: 

http://api.jotform.com/docs/

https://developers.jotform.com/libraries

And this guide will also help you to send the submitted data to your MySQL database: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

Hope this helps.